|MS SQL Server 2012 - DBA Articles|
SAVE Transaction Process Flow
SAVE Transaction is used to sets a savepoint within a transaction.
savepoint_name is the name assigned to the savepoint.
@savepoint_variable is the 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.
The following example is used to stores some product information in PRODUCT_MASTER table.
Query Output Screen
* * * * *