Updating multiple tables sql server
Unlike stored procedures (which also support parameters), these parameterized functions can be updateable, as you'll see later in this chapter.
The SQL-92 standard also mandates that views cannot be sorted with an values with a view; to support that, it also supports sorting.
The triggers in views are covered later in this chapter.
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.
Therefore, make sure that you save your view definition in a script file in case you ever need to modify it.
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.
Views still, however, don't allow you to perform any of the other major SQL actions besides selecting—views can't contain syntax when defining a view.
The primary use of views is to present data to users of an application.