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?