Advantages and Disadvantages of Cursor?
Answer Posted / krishna sandeep
Advantage:
you can do row vise validation from a table
Disadvantage:
of example you are retrieving 100 row...
every single row you retrieve will hit the server as a
single select query so performance will be low.
Is This Answer Correct ? | 122 Yes | 17 No |
Post New Answer View All Answers
What are ddl (data definition language) statements for tables in ms sql server?
Working with TLogs
What is the difference between truncate and delete commands?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Explain what you mean by 3 tier architecture.
How to delete existing rows in a table?
What is merge join?
What is the purpose of the master database?
How to loop through result set objects using mssql_fetch_array()?
What is the purpose of grouping data in a report?
What is openrowset sql server?
What is amo? : sql server analysis services, ssas
What is the difference between for auto and for nested?
How to restore performance issues and how to check?
do views contain data ?