Gaurav Malviya
Can a view be updated/inserted/deleted? If Yes โ€“ under what conditions?
By Gaurav Malviya in SQL Server on Jan 14 2014
  • Kumar Sambhav
    Oct, 2014 8

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

    • 0
  • Vikas Ahlawat
    Jul, 2014 30

    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

    • 0
  • Rakesh Singh
    Apr, 2014 2

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

    • 0
  • Gaurav Malviya
    Jan, 2014 14

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS