What are the advantages of using views. Why do we need
views when we have SPs?

Answer Posted / jk.garg25

Views can be update, delete or insert

Is This Answer Correct ?    8 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 3 types of schema?

597


What are the extra roles available in msdb? : sql server security

633


What is similarity and difference between truncate and delete in sql?

586


What is exporting and importing utility?

603


How can you check the version of sql server?

555






What is function of ROLLUP ?

642


Which tcl commands are available on the sql server?

601


How can you find out how many rows returned in a cursor?

547


what are the different types of SSRS reports?

112


how you can deploy an ssrs report?

127


What do you understand by intent locks?

571


Give an example of why you would want to denormalize a database

507


List the different types of collation sensitivities in sql server?

520


How to get the definition of a view out of the sql server?

498


What is difference between inner join and join?

536