What is a cursor in SQL Server 2000 and their types?
Answer Posted / rajiv rohilla
In SQL Server 2000 Cursors are used in stored procedures /
Functions where we have to go each record of a recordset
one by one.
| Is This Answer Correct ? | 16 Yes | 6 No |
Post New Answer View All Answers
How to create a simple table to test triggers in ms sql server?
Can we check locks in database? If so, how can we do this lock check?
What is index in an assignment?
How to convert a unicode strings to non-unicode strings?
What is format parameter in ssrs?
How to perform key word search in tables?
Explain primary key?
Define inner join in sql server joins?
Can we do dml on views?
What is meant by dirty read?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What the different topologies in which replication can be configured?
How to remove duplicate rows from table except one?
How to copy data from one table to another table?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration