What is the difference between a Local temporary table and a
Global temporary table? How is each one used?
Answer Posted / sarvesh nakhate
A local temporary table exists only for the duration of a
connection or, if defined inside a compound statement, for
the duration of the compound statement.
A global temporary table remains in the database
permanently, but the rows exist only within a given
connection. When connection is closed, the data in the
global temporary table disappears. However, the table
definition remains with the database for access when
database is opened next time.
| Is This Answer Correct ? | 17 Yes | 9 No |
Post New Answer View All Answers
Do you have any idea about the tcl commands?
What is the Control Flow in SSIS
How to modify existing triggers using "alter trigger"?
What is difference between index and primary key?
What is data compression? : sql server database administration
what is difference between NULL and ISNULL in SQL Server 2008?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What options are available to audit login activity? : sql server security
Explain transaction server implicit?
What is a trace frag?
What is Replication?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is an sql server agent?
If the job running very slow what is the action you do
Does a full backup include transaction log?