Advantages and Disadvantages of Cursor?
Answer Posted / nnnnhgg
no disadvantahes
| Is This Answer Correct ? | 9 Yes | 88 No |
Post New Answer View All Answers
Can we update data in a view?
Tell about MOM Tool(Microsoft Operator Manager)?
What are the purpose of Normalisation?
Explain temporary table vs table variable by using cursor alternative?
What are the methods used to protect against sql injection attack?
What do you understand by the data quality services in sql server?
What are the differences between union, intersect, and minus operators?
What is difference between inner join and join?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How to convert character strings into numeric values?
What is the difference between index seek vs. Index scan?
What are null values in ms sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is an execution plan? When would you use it?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.