sp_getbindtoken also can be used for transactions.

The Transact-SQL statement or statements that follow GOTO are skipped and processing continues at the label.

Output parameters, which can return either data (such as an integer or character value) or a cursor variable (cursors are result sets that can be retrieved one row at a time).

The script builds an SQL query by concatenating hard-coded strings together with a string entered by the user.