Sql server update views

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? The first thing that comes to mind is a trigger. Again, in that stored procedure, you would likely have code to split the work into two statements.

In the underlying query within your View, you can definitely have one or more columns that are derived. Ok, so the new Email column is technically a derived column now. Yep, still fails! This last topic is something you should be aware of if you plan on inserting or updating data through Views. Therefore, they are excluded from the result set of the View.

There is a simple way to prevent users from modifying data to where it would violate the filters of the View. In other words, we can add a setting to prevent users from changing a row from one they can see to a row they cannot see. We would add those keywords to the very end of the View, like this:. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 1. Related Hot Network Questions. The data "in" a view has no existence independent from the tables that make up the view. The data is stored in the original tables and only "assembled" into the view when you want to look at it. If the view is updateable not all views are the updates are applied to the table data. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. If I update a view, will my original tables get updated Ask Question. Asked 11 years, 9 months ago. Active 4 years, 1 month ago. Viewed k times. If I update the view, will the data in the original table get updated? Improve this question.