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
- 19829 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 backup SQL Server Reporting Services ?
Difference between Logical Page and Physical Page in SSRS.
Why and when do stored procedure recompile?
What is Command line parameters in PLSQL.?
How will you know when statistics on a table are obsolete?
Can we shrink data file in sql server?
Define left outer join in sql server joins?
Difference between report and query parameter.
How to list all objects in a given schema?
Explain the rules for designing files and file groups in sql server?
What are diverse clauses that form a part of sql?
When would you prefer to have a minimum number of indexes?
How to remove duplicate rows from table?
How can we get count of the number of records in a table?
What are .mdf files?
