How global temporary tables are represented and its scope?
- 1 Answers
- 1047 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ganesh Soni
Global temporary tables (GTTs) in SQL Server are prefixed with two '#' symbols. They can be accessed by any user session that connects to the instance of SQL Server after their creation. Their scope ends when the connection ends, or explicitly dropped. If no connection is accessing a GTT, it will be automatically dropped.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to enter binary string literals in ms sql server?
What are different types of constraints?
Why and when do stored procedure recompile?
Why use identity in sql server?
How efficient you are in oracle and SQL server?
What are the kinds of subquery?
What are the different types of subquery?
How to remove duplicate rows from table except one?
Disadvantages of the indexes?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Can you index views?
How to convert numeric expression data types using the cast() function?
what is spatial nonclustered index
what is the difference between openrowset and openquery?
Is it possible to have clustered index on separate drive from original table location?
