Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 101400 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / vivekanand
Merits: Row by Row Validations, good choice for small set of records
De-Merits: it Increases Network Traffic, result to slowdown the Speed and Performance of the Database,
Consumes More Resources, bad choice for large set of records.
Cheers,Vivekanand
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a function and a stored procedure?
What is normalization of database?
What are the restrictions that views have to follow? : SQL Server Architecture
What is a trace frag? Where do we use it?
What is filestream?
How do I determine how many instances of sql server are installed on a computer?
What is the new security features added in sql server 2016? : sql server security
Explain insert into select statement?
What is the order by used for?
What are the different types of stored procedures?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How to truncate the log in sql server 2012? : sql server database administration
How to enter comments in transact-sql statements?
Define Joins?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
