Can a view be updated/inserted/deleted? If Yes

By using of Instead of Trigger you can insert into multiple table in view but in table should be check constraint

For SQL SERVER INTERVIEW QUERIES QUESTION FOLLOW THE BELOW LINK MORE THAN 100 MS SQL SERVER INTERVIEW QUERIES WITH EXAMPLE http://www.interviewquestionspdf.com/2014/07/sql-queries-interview-questions-answers.html

Vikas Ahlawat12y

Yes, You Can Insert-update-Delete View,If only exists One table you Can't Insert-Update-delete View more than One Tables.

Rakesh Singh12y

A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

Gaurav Malviya12y

Can a view be updated/inserted/deleted? If Yes – under what conditions?

4 Answers