T-SQL doesn't have such kind of cursors but there're always other ways to achive the same result.

>I'm trying to learn T-Sql, and in the books on-line I can't find info about this.
>
>I remember I used to declare cursors with parameters in Oracle Pl/Sql and i'm trying to achieve that in T-Sql.
>
>For example:
>
>I have a table for the clients info., I need a cursor that retrieves information for a specific clientcode.
>
>If i'm in a stored procedure, I declare my cursor with the parameter (clientcode) then I open the cursor (On this point I have the info for the clientcode X), later I need to retrieve information for another clientcode based on the same cursor. I would like to open the cursor with the parameter clientcode Y.
>
>Open CursorName (Param1, Param2, ...)
>
>Something like that.
>
>Is it posible?