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 currentsession, 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
temporarytable names with a double number sign (##table_name)
why ## and not # :-\
Oh, I see… There is no such an option 🙂