in Technology by (55.8k points)
How Global temporary tables are represented and its scope?

1 Answer

0 votes
by (55.8k points)

How Global temporary tables are represented and its scope?

Global temporary tables are represented with ## before the table name. Scope will be the outside the session whereas local temporary tables are inside the session. Session ID can be found using @@SPID.

Related questions

0 votes
asked Mar 1 in Education by JackTerrance (1.8m points)
...