4
Reply

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

Gaurav Malviya

Gaurav Malviya

10y
5.2k
1
Reply

    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

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

    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.