If cursor not updating rollback is required
It is used in a lot of applications as internal data storage.
These locks are not released, and they are not converted back to their previous lock mode. The following example shows the effect of rolling back a named transaction.After closing the opened cursor or before closing the opened cursor?Below is the procedure im using, am i doing it in correct way?You can use ROLLBACK TRANSACTION to erase all data modifications made from the start of the transaction or to a savepoint. Transact-SQL Syntax Conventions Is name of a user-defined variable containing a valid savepoint name.The variable must be declared with a char, varchar, nchar, or nvarchar data type.