Advantages and Disadvantages of Cursor?
- 15 Answers
- 97852 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / krishna sandeep
Advantage:
you can do row vise validation from a table
Disadvantage:
of example you are retrieving 100 row...
every single row you retrieve will hit the server as a
single select query so performance will be low.
| Is This Answer Correct ? | 122 Yes | 17 No |
Post New Answer View All Answers
What is data mart? : sql server analysis services, ssas
How can you insert null values in a column while inserting the data?
What are secondary xml indexes?
wat wil hapn if we give the both read and deny read permission to user?
How to find the source of a table in sql server?
how to take backup bcp out for a column in table in sql server?
What is a constant or literal in ms sql server?
What are the different authentication modes in sql server? How can it be changed?
What is the concept of optimization?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is the purpose of floor function?
Explain how would you store your query in an SSRS report or a Database server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Is sql different from sql server?
Explain active/passive and active/active cluster configurations?
