What is the difference between local table and global table
Answer / 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 |
What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
How to delete duplicate records based on single column from a table?
0 Answers Petranics Solutions,
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Difference between connected and disconnected database in .net with sql server?
last function used in MS Access to convert sql what function will use in sql
How to execute stored procedure and set temp table in sql server?
How to delete a database in ms sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
how to find number of columns in a table in sql server 2000 and 2005 also
What are the grouping functions?
Can a function call a stored procedure in sql server?
what is difference between primary key and Unique