Can a view be updated/inserted/deleted? If Yes – under what conditions? SQL Server Interview Question

SQL Server Interview Question: Can a view be updated/inserted/deleted? If Yes – under what conditions?
Ans: 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.
Click here for more than 300 Sql server Interview questions

Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.