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 T-SQL command should you recommend?
A.
CREATE TABLE ##Table…
B.
CREATE TABLE Table…
C.
CREATE VIEW Table…
D.
CREATE PARTITION SCHEME Table…
E.
DECLARE TABLE @ Table…
Explanation:
Temporary Tables
You can create local and global temporary tables. Local temporary tables are visible only in the current session,
and global temporary tables are visible to all sessions. Temporary tables cannot be partitioned.
Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table
names with a double number sign (##table_name)