Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
✍: Guest
Answer1:
Local templrary table will have a single # (#tablename) appended with the table name.Global templrary table will have Double # (##tablename) appended with the table name.
Ex:create table #table1
local temp. table will be available until the session who created it logs out, but global temp. table is available till the last session gets close in SQLServer.
Answer1:
Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions.Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name).
2014-10-15, 1531👍, 0💬
Popular Posts:
How can I implement a variable field width with printf? That is, instead of something like %8d, I wa...
Once I have developed the COM wrapper do I have to still register the COM in registry? Yes.
How To Specify Two Background Images on a Page? - CSS Tutorials - Page Layout and Background Image D...
How do we enable SQL Cache Dependency in ASP.NET 2.0? Below are the broader steps to enable a SQL Ca...
How To Enter Boolean Values in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want...