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
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How to create indexed view?
How to define the name and server for a new dsn?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How to backup encryption key ?
Write a sql query to display the current date?
Describe the left outer join & right outer join. : sql server database administration
Can you always create a cache of a report?
Can binary strings be converted into numeric or float data types?
Can You Use Data Mining Models In Ssrs?
What is optimistic concurrency?
how you can configure a running aggregate in SSRS?
How can we delete a table in sql server?
How many types of built in functions are there in sql server 2012?
Can an automatic recovery be initiated by a user?
