How Global temporary tables are represented and its scope?

Report
Question
9 views

Please explain why do you think this question should be reported?

Report Cancel

A global temporary table is created using CREATE TABLE statement with the table name prefixed with a double number sign (##table_name).Scope will be the outside the session while nearby brief tables are inside the session. Session ID can be discovered utilizing @@SPID.

Please follow and like us:

About the Author