What is a cursor in SQL Server 2000 and their types?
Answer Posted / saswat gupta
Cursor is a datatype that is not used in table. and only
used in stored Procedure/function
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What structure can you implement for the database to speed up table reads?
How to find the list of fixed hard drive and free space on server?
What is an expensive query?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What are the different types of backups that exist?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
please differentiate between delete and truncate?
What is 2nf example?
what is create database syntax? : Sql server database administration
Why people hate cursor?
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?
What is raid? : SQL Server Architecture
What is the purpose of grouping data in a report?
What is cte (common table expression)?
Can you move the resources after pausing the node? : sql server database administration