What is the difference between local table and global table
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
explain different types of backups avaialabe in sql server? : Sql server database administration
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How do you implement session management in SQL Server mode?
What is a self join in sql server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How to convert numeric expression data types by assignment operations?
Where do you find the default Index fill factor and how to change it?
What is the use of stored procedure?
Define outer join in sql server joins?
Is the primary key column of a table an index in ms sql server?
What is bcnf normalization form?
Different types of keys in SQL?
Difference between Sql server reporting services and Crystal reports?
What is ddl and dml commands?
What do we need queues in sql service broker?