82 Working with views in sql server

Working with views in sql server
Download the scripts used in the video from here: drive.google.c...
SQL Server tutorials: • SQL tutorial for begin...
SQL Server Developer Interview questions: • Sql server developer i...
Working with views in sql server
How many types of views are there in SQL Server?
How to get data from view in SQL Server?
What is the advantage of using views in SQL?
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@trishaghoshal5856]

Hi in what cases view does not allow Insert update delete to source base table?

[@learnssis]

You can modify the data of an underlying base table through a view, as long as the following conditions are true: Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table. So if you are fetching data into a view from multiple tables then you might get issues while updating the data.