When SET CURSOR_CLOSE_ON_COMMIT is OFF, a ROLLBACK statement closes only open asynchronous cursors that are not fully populated. STATIC or INSENSITIVE cursors that were opened after modifications were ...

Arguments cursor_name Is the name of the [!INCLUDE tsql] server cursor defined. cursor_name must conform to the rules for identifiers. INSENSITIVE Defines a cursor that makes a temporary copy of the ...

Learn what are some common performance pitfalls when using cursors in T-SQL stored procedures and how to avoid or optimize them with tips and best practices.

T-SQL Populating local variables from cursor rluciano Jul 10, 2007 Jump to latest Follow Reply ...