Updating sql view

Rated 3.96/5 based on 732 customer reviews

If the view is updateable (not all views are) the updates are applied to the table data.

updating sql view-8

updating sql view-58

updating sql view-35

To return the top 10 customers or the top 10% of customers, based on sales over the past year, SQL Server needs to sort customers by sales.An updatable view is a view which contains all the not null columns from the underlying table.When modifying data through a view (that is, using INSERT or UPDATE statements) certain limitations exist depending upon the type of view.Views that access multiple tables can only modify one of the tables in the view.Views that use functions, specify DISTINCT, or utilize the GROUP BY clause may not be updated.

Leave a Reply