What is a cursor in SQL Server 2000 and their types?
Answer Posted / lekhraj deshmukh
Cursor:-Cursor is used for fetching the ror by row data from
tables.
Note:-Cursor is the only datatypa that can not be used in
table creation.
When will be use cursor need to perform following steps:-
1)decalere a cursor
2) open a cursor
3)fetch the cursor
4)close the cursor
5)deallocate the cursor
Types of cursor:-
1)API cursor
2)client cursor
3)sql server cursor
Is This Answer Correct ? | 9 Yes | 10 No |
Post New Answer View All Answers
Explain what are the authentication modes in sql server?
Do you know what is xpath?
What is page in sql server?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is transact-sql ddl trigger?
How can a user-defined datatype be created?
how can u get last observation in an unknown dataset ?
Why variables called the most powerful component of ssis?
What are the approximate numeric data types?
What is de-normalization and what are some of the examples of it?
Explain in brief how sql server enhances scalability of the database system?
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
What is catalog views?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is RAID? What are the different types of RAID configurations?