1. Back To Blog

SQL Server Interview Question and answers - Are SQL Server views updatable?

• By Shiv Prasad Koirala in SQL
• Nov 22nd, 2012
• 2051
• 0

Taken from the best selling SQL Server interview question book,you can see more about the book by clicking on SQL Server interview questions and answers book.

 

You can only update columns of view if they come from the same base table.If your view is using multiple base tables,you cannot update multiple columns from multiple base tables.

 

For instance if you have a view which uses "Customer" and "Address" base table,you can either update "Customer" base tables columns or "Address" base table columns at time. But not both of them in one go.

 

 

 

 

In case you trying to update multiple base tables you will get an error as shown in the above figure.

 

Also watch my most asked SQL Server interview question and answer:-

 

See more stuffs on SQL server interveiw questions

 

Regards,

 

Click to view moreSQL server interview questions