Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between local table and global table
- 1 Answers
- 7385 Views
- CarrizalSoft Technologies, Polaris, I also Faced
- E-Mail Answers
Answer Posted / radha
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 | 7 No |
Post New Answer View All Answers
Do you know the isolation level that sql server support?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are the different SQL Server Versions you have worked on?
How to update a field in SQL after ALTERING a row?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is the maximum size of column in sql server?
Can we store videos inside the sql server table?
What is filtered index?
What is unpivot?
What are diverse clauses that form a part of sql?
Is sql server free?
How is SQL Azure different than SQL server?
How to turn on the mssql api module in php?
How to transfer a table from one schema to another?
how to trace the traffic hitting a sql server? : Sql server database administration
