4
Reply

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

Gaurav Malviya

Gaurav Malviya

Jan 14, 2014
5.2k
1

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

    Kumar Sambhav
    October 08, 2014
    0

    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 Ahlawat
    July 30, 2014
    0

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

    Rakesh Singh
    April 02, 2014
    0

    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 Malviya
    January 14, 2014
    0