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...
You plan to modify a stored procedure to use temporary data. The stored procedure must meet the following requirements:
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You plan to modify a stored procedure to use temporary data. The stored procedure must meet the following requirements:
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!