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 |
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are the types of model in sql server and explain
What is the recursive stored procedure in sql server?
What is the difference between varchar and nvarchar?
How many types of stored procedures are there in sql server?
What objects does the fn_my_permissions function reports on? : sql server security
What is database mirroring?
Explain what is the purpose of sql profiler in sql server?
What is a Lock and let me know Different types of locks?
Which data type columns are the best candidates for full-text indexing?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is 1nf normalization form?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)