0 votes
10 views
How Global temporary tables are represented and its scope?
in Technology by (51.6k points)

1 Answer

0 votes

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.

by (51.6k points)

Related questions

+1 vote
1 answer 17 views
17 views asked Oct 14, 2020 in Technology by JackTerrance (190k points)
0 votes
1 answer 16 views
0 votes
1 answer 14 views
0 votes
1 answer 9 views
9 views asked Dec 8, 2020 in Technology by JackTerrance (190k points)
0 votes
1 answer 13 views
0 votes
1 answer 19 views
0 votes
1 answer 22 views
0 votes
1 answer 101 views
101 views asked Dec 20, 2020 in Technology by Editorial Staff (51.6k points)
0 votes
1 answer 20 views
+1 vote
1 answer 18 views
0 votes
1 answer 79 views
0 votes
1 answer 22 views
0 votes
1 answer 10 views
10 views asked Nov 9, 2020 in Technology by Editorial Staff (51.6k points)
0 votes
1 answer 19 views
0 votes
1 answer 18 views
18 views asked Nov 22, 2020 in Technology by JackTerrance (190k points)
0 votes
1 answer 13 views
...