1.what is the difference between view and cursor?

2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks

Answer Posted / bindu

Both Cursors and Views doesn't store data , so their is no chance to affect the DB.

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of storage modes? : sql server analysis services, ssas

584


Explain what are magic tables in sql server?

538


What do you mean by a dependent functionality in a build?

661


What are trace files?

535


How to download and install microsoft sql server management studio express?

565






What are the differences between triggers and stored procedures?

538


What is command parameter in ssrs?

120


What is the main purpose of having conversation group?

498


Delete duplicate rows without using rowid.

1074


What is read committed?

607


How to select some specific rows from a table in ms sql server?

574


What are data files?

583


How to declare and use cursor variables?

587


what are isolation levels? : Sql server database administration

497


What is temporary table in sql server? Why we use temp table?

518