What is a cursor in SQL Server 2000 and their types?
Answer Posted / sd
Cursors allow row-by-row prcessing of the resultsets.
Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven
Is This Answer Correct ? | 30 Yes | 7 No |
Post New Answer View All Answers
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What does it mean if @@cursor_row returns a negative number?
Give a example to search fr a string in all stored procedure in sql server.
What according to you is the difference between mysql and sql server performance?
Explain what is meant by replication of database?
What are the different types of columns types constraints in the sql server?
What is the purpose of the tempdb database?
What is indexing in sql server with example?
Explain full-text query in sql server?
What is save transaction and save point?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to skip remaining statements in a loop block using continue statements?
What is a data source file?
What is the language structure to add a record to a table?
Explain microsoft sql server functions?