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
What do you mean by data manipulation language?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Explain syntax for viewing, dropping and disabling triggers?
What is the tcp/ip port on which sql server runs?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Comment,Datatypes are unlimited
What is open database communication (odbc)?
What is ms sql server service broker?
do you know how to configure db2 side of the application? : Sql server database administration
What is a database table?
Explain how you can deploy an SSRS report?
How to call stored procedure using http soap?
How can I check if a view exists in a sql server database?
What is ssrs?