Updating table from a view in sql
To create a view, a user must have the appropriate system privilege according to the specific implementation.
Another limitation of views that you may be familiar with is that a view cannot be indexed. In SQL Server 2000, you can indeed create indexed views, as shown later in this chapter.A user can query a single view instead of having to learn complex join syntax and understand the structure of your database.As far as the user is concerned, the view looks just like a table.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.So, a view that returns the top 100% by sales would essentially be a sorted view.
Search for updating table from a view in sql:
Unlike stored procedures (which also support parameters), these parameterized functions can be updateable, as you'll see later in this chapter.