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
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is Extended user-defined?
What are the disadvantages of using the stored procedures?
How to enter unicode character string literals in ms sql server?
What are alternate keys?
What is stored in the mssqlsystemresource database? : sql server database administration
What is normalization 1nf 2nf 3nf?
How to add code to the existing article (using improve article)?
What is a heap?
What is optimistic concurrency?
Write a SQL query to delete a table?
What is triggers in ms sql server?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is tablix?
What are the default system databases in sql server 2000?