Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between local table and global table
- 1 Answers
- 7539 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
How can I tell if sql server is 32 or 64 bit?
How to find which stored procedure is currently running in sql server?
What language is sql server written in?
How do you delete a trigger?
Define synonym?
What is explicit cursors?
What is a result set object returned by mssql_query()?
What is bcp? When does it use?
What are database states in ms sql server?
How to retrieve field values using mssql_result()?
What is the difference between a clustered index and a non-clustered index?
What are the different types of normalization?
What is bulkcopy in sql?
What structure can you implement for the database to speed up table reads?
how you can configure a running aggregate in SSRS?
