Answer Posted / sumit
The Life Span of the Cursor is till the runtime of the
stored procedure/function in sql server 2005
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is b tree index?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How does index makes search faster?
What are temporal tables in sql server 2016?
What are user defined functions in ms sql server?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Write a sql query to delete duplicate records from a table called table1
To which devices can a backup be created and where should these devices be located? : sql server management studio
optimization techinques
Does a specific recovery model need to be used for a replicated database? : sql server replication
How to use “drop” keyword in sql server and give an example?
What is outer join in sql server joins?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Indexes are updated automatically is the full-text index also updated automatically?
Can we do dml on views?
