Advantages and Disadvantages of Cursor?
Answer Posted / karthikumar.r
advantage:we can do row vise validation.
disadvantage:performance is less
Is This Answer Correct ? | 103 Yes | 18 No |
Post New Answer View All Answers
How do you identify a foreign key?
What is nolock?
What are the database objects? : SQL Server Architecture
What is the difference between Normalization and De-normalization?
Explain the Ways to improve the performance of a sql azure database?
Explain what is the use of custom fields in report?
How do I open a .db file?
Why should we go for stored procedures? Why not direct queries?
What is the use of toad or sqldbx.?
What is the difference between clustered index and primary key?
Describe in brief authentication modes in sql server.
What it means to be triggered?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How do you drop an index?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?