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 questionsAns: 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.
Comments