Views can be update, delete or insert

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

Question Posted / jk.garg25

Answer Posted / jk.garg25

Is This Answer Correct ?

8 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

915

What are the steps to follow to configure SQL*Net?

1033

Explain rdbms?

1032

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

945

How to maintain a fill factor in existing indexes?

1001

what are cursors? : Sql server database administration

1060

Difference between report and query parameter.

1093

What is the synonym of join?

957

What is query parameter in ssrs?

160

Can two tables share a primary key?

1018

What does it mean to invest in the index?

965

When cursors are useful?

1097

What does set rowcount do?

907

What is thr feature of change data capture?

978

Can sql server 2016 run on windows 7?

912