Answer Posted / Jhamman Lal
A global temporary object (table or stored procedure) is an object that is accessible to all connections in the instance of SQL Server. When a global temporary object is created, it's given a unique system-generated name and exists only for the duration of the current database session.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the different subsets of sql?
Explain “row_number()” in sql server with an example?
Does view occupy space?
do you know how to configure db2 side of the application? : Sql server database administration
What is normalization and what are the advantages of it?
What is standby servers? Explain types of standby servers.
What is a coalesce function?
what is the difference between openrowset and openquery?
How raid can influence database performance?
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?
What is the primary use of the model database?
Equi join and non equi join is possible with sql server?
What is sql server query analyzer?
Why and when do stored procedure recompile?
