Q1
Single choice
You plan to modify a stored procedure to use temporary data.
The stored procedure must meet the following requirements:
1. Favor physical memory when physical memory is available.
2. Be able to roll back changes to the temporary data.
You need to recommend which object to add to the stored procedure.
Which Transact-SQL command should you recommend?