You plan to modify a stored procedure to use temporary data. The stored procedure must meet the following requirements:
Posted: Mon Oct 17, 2022 4:50 pm
You plan to modify a stored procedure to use temporary data.
The stored procedure must meet the following requirements:
✑ Favor physical memory when physical memory is available.
✑ 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?
A. CREATE TABLE ##Table...
B. CREATE DEFAULT Table...
C. CREATE VIEW Table...
D. DECLARE TABLE @ Table...
The stored procedure must meet the following requirements:
✑ Favor physical memory when physical memory is available.
✑ 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?
A. CREATE TABLE ##Table...
B. CREATE DEFAULT Table...
C. CREATE VIEW Table...
D. DECLARE TABLE @ Table...