Updating a view sql server

The view is, in essence, a stored SELECT statement that masquerades as a table.The data is stored in the original tables and only "assembled" into the view when you want to look at it.In the columns for the view, the permissions for a column name apply across a CREATE VIEW or ALTER VIEW statement, regardless of the source of the underlying data.For example, if permissions are granted on the Sales Order ID column in a CREATE VIEW statement, an ALTER VIEW statement can rename the Sales Order ID column, such as to Order Ref, and still have the permissions associated with the view using Sales Order ID.

updating a view sql server-42

When modifying data through a view (that is, using INSERT or UPDATE statements) certain limitations exist depending upon the type of view.

The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

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

If you forget this in the future, you can always right click on the view in SQL Server Management Studio and select 'Modify' this will give you the current query, with the correct syntax for altering it.

756

Leave a Reply

  1. Cyber free sexy text chat java phone 11-Aug-2017 08:21

    We go out of our way to do this as you will see when you use our personalized service.

  2. david lautour dating 29-Aug-2017 12:15

    Shag Book® and SNRG Ventures are in no way associated or affiliated with, or endorsed or sponsored by, Facebook.