Advantages and Disadvantages of Cursor?
- 15 Answers
- 98014 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / hiral bhatt
Dear All,
Cursor, its an object in SQL Server and the main advantages
of cursor is that whenevr we need to fetch records in row
by row Manner..
But using cursor, it itself is not a good concept, we have
another alternate for cursor like Temp Table.
Regards
Hiral Bhatt
Sr. Software Engg.
| Is This Answer Correct ? | 43 Yes | 21 No |
Post New Answer View All Answers
What is scheduled job and how to create it?
What are the features of Embedded SQL
What is the syntax for encrypting a column in SQL Server?
Explain syntax for dropping triggers?
How do I view a script in sql server?
How to get @@error and @@rowcount at the same time?
A trigger can reference objects outside the current database? State true or false.
how you can configure a running aggregate in SSRS?
What is parameterized reports in ssrs ?
Explain mixed authentication mode of sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the different types of locks in the database?
What is side by side migration in sql server?
What are “lock” hints?
What are cursors stored procedures and triggers?
