What is the difference between local table and global table
Answer Posted / radha
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 | 7 No |
Post New Answer View All Answers
What are ddl triggers and types of ddl trigger?
What is resource db in sql server?
What is the difference between for xml raw and for xml auto?
What is format parameter in ssrs?
How to test values returned by a subquery with the in operator?
What is resource governor?
Does sql server 2000 full-text search support clustering?
How to retrieve field values using mssql_result()?
What is database isolation in sql server? : sql server database administration
How do use Having,Group by,Group function in SQL?
What are the different types of subquery?
Does any body please help me what question's have asked for SSRS in the interview?
Working with TLogs
What is the maximum size per database for sql server express?
How do I view a script in sql server?