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
- 19964 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 are the differences between user defined functions and stored procedures?
How do I create an extended event in sql server?
Which database stores information about replication?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Which sql server table is used to hold the stored procedure scripts?
What are character string data types in ms sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
How will you find out if there are expensive SQL statements running or not?
When to use null data driven subscription?
What is SQL Azure?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
How can change procedure in sql server?
What is RMS migrations?
What is a non equi join?
