Can I reset cursor's position to the beginning?

Question

you need to declare your cursor as scroll, like this

declare c scroll cursor for (select statement); 

then at any time for locating to the first just use the following

fetch first from c;

Another option that can be used that doesn't force you to change the type of cursor is simply to close the cursor and re-open it:

CLOSE user_cursor
OPEN user_cursor

But the scroll option will be cheaper in terms of resource usage, if that's a change you can accept.

The data retrieved by the cursor will not change.

STATIC

Defines a cursor that makes a temporary copy of the data to be used by the cursor. All requests to the cursor are answered from this temporary table in tempdb; therefore, modifications made to base tables are not reflected in the data returned by fetches made to this cursor, and this cursor does not allow modifications.