Transactions Locks «Prev 

SAVE TRANSACTION syntax (Transact-SQL)

You entered:
Applies To: SQL Server 2014, SQL Server 2016 Preview
Sets a savepoint within a transaction.
Topic link icon Transact-SQL Syntax Conventions
SAVE { TRAN | TRANSACTION } { savepoint_name | @savepoint_variable }
[ ; ]

savepoint_name is the name of your savepoint. This is used to identify the point in the transaction where you might want to rollback to.

@savepoint_variable is the name of your savepoint as stored in a variable.