Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Local temporary table and a
Global temporary table? How is each one used?
- 2 Answers
- 20049 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 use of attribute hierarchy optimized state? : sql server analysis services, ssas
Explain what are the events recorded in a transaction log?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Explain microsoft sql server functions?
Explain what is the use of custom fields in report?
Explain what is raid and what are different types of raid levels?
When you should use a low fill factor?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Which is the latest version of sql server and when it is released?
How are the unique and primary key constraints different?
What is the new security features added in sql server 2014? : sql server security
What is service broker?
What does select 1 mean?
What are the advantages of using stored procedures?
Is it ok to shrink transaction log?
