Answer Posted / Shubhangi
Implicit cursors are automatically created by SQL Server when a SELECT statement is used within the execution of a transaction-control construct, such as BEGIN TRANSACTION and COMMIT. Implicit cursors are closed and deallocated after each transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is temporary table in sql server? Why we use temp table?
Why use identity in sql server?
How to rebuild the master database?
What are the different types of subquery?
Can we shrink data file in sql server?
What is standby servers? Explain types of standby servers.
Where can you add custom error messages to sql server?
What is subquery? Explain the properties of a subquery?
Can we do dml on views?
How to convert numeric expression data types using the cast() function?
What is the difference between for xml raw and for xml auto?
How do I find query history in sql server?
What is sql or structured query language?
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?
List out the different types of locks available in sql server?
