What is the difference between a Local temporary table and a
Global temporary table? How is each one used?
- 2 Answers
- 18915 Views
- HCL, I also Faced
- E-Mail Answers
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 is function of ROLLUP ?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Explain what is raid and what are different types of raid levels?
What is difference between count (*) and count 1?
Differentiate sql server reporting services vs. Crystal reports?
How to use wildcard characters in like operations in ms sql server?
What are different types of raid configurations? : SQL Server Architecture
How to use values from other tables in update statements in ms sql server?
What is the correct order of the logical query processing phases?
What is the use of commit?
What is the difference between dropping a database and taking a database offline?
What is the New in SQL server 2008?
What is the fastest way to permanently delete a 1 million row table named customers?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
what is normalization? : Sql server database administration
