Advantages and Disadvantages of Cursor?
Answer Posted / karthikumar.r
advantage:we can do row vise validation.
disadvantage:performance is less
| Is This Answer Correct ? | 104 Yes | 18 No |
Post New Answer View All Answers
Explain for xml explicit mode?
What is rtm version in sql server?
How to encrypt Strored Procedure in SQL SERVER?
How to create prepared statements using odbc_prepare()?
What are the methods used to protect against sql injection attack?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Can you please explain the difference between primary keys and foreign keys?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Explain the steps needed to create a scheduled job?
What is model database in sql server?
How to edit table in sql server 2017?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How to divide query output into multiple groups with the group by clause in ms sql server?
How to use order by with union operators in ms sql server?
how would you troubleshoot blocking? : Sql server database administration