Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between local table and global table
- 1 Answers
- 7472 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
Differentiate between ms sql server reporting services vs crystal reports?
How to make a column nullable?
What are the difference between primary keys and foreign keys?
Explain different types of collation sensitivity?
What stored by the msdb?
Explain syntax for viewing, dropping and disabling triggers?
Which database stores information about replication?
Do you know what is sql injection?
What are ddl triggers and types of ddl trigger?
What do you understand by intent locks?
How can sql injection be stopped? : sql server security
How to find table changes in sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is the difference between for trigger and after trigger?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
