What is the difference between a Local temporary table and a
Global temporary table? How is each one used?
- 2 Answers
- 19363 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
How to get the definition of a user defined function back?
How to create a store procedure with encryption?
What are the indexes in sql server?
If the job running very slow what is the action you do
Tell me what do we need queues in sql service broker?
Explain log shipping?
What is cursors?
wat wil hapn if we give the both read and deny read permission to user?
What is subquery? Explain the properties of a subquery?
What are the differences between triggers and stored procedures?
What is the architecture of ms sql reporting service?
How to see the event list of an existing trigger using sys.trigger_events?
1 01 101 01010
How to test odbc dsn connection settings?
How to view existing indexes on an given table using sys.indexes?
