Wednesday, 6 January 2016

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

WHAT OTHERS ARE READING/RELATED TO THIS:

0 comments:

Post a Comment