Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between local table and global table
- 1 Answers
- 7483 Views
- CarrizalSoft Technologies, Polaris, I also Faced
- E-Mail Answers
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 does it mean to manipulate data?
Give me any three differences between Truncate and Delete.
How to copy data from one table to another table?
What is the importance of a recovery model?
What are the steps to follow to configure SQL*Net?
What are statistics, under what circumstances they go out of date, how do you update them?
How to count the number of duplicate items in a table?
What is difference between restoration and recovery in SQLServer?
How to see existing views in ms sql server?
What are joins in sql and what are the different types of joins?
What is triggers in ms sql server?
What is the default value of an integer data type in sql server 2005?
-
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)
