Advantages and Disadvantages of Cursor?
- 15 Answers
- 96648 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
Explain about local stored procedure?
How to get a list of all tables with "sys.tables" view in ms sql server?
What are sub reports and how to create them?
What is relationship? What number of sorts of relationship are there?
What is the difference between set and select?
What is reportserver and reportservertempdb ?
Tell about MOM Tool(Microsoft Operator Manager)?
How to Check if table exists in sql server?
What are the differences between lost updates and uncommitted dependencies?
What is left outer join in sql server joins?
What is system stored procedures?
how would you troubleshoot blocking? : Sql server database administration
what are the types of indexes? : Sql server database administration
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is difference between view and materialized view?
