Database updating view
15-Jul-2020 00:16
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.
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.
Views can be used in place of tables in your Access front-end application, whether you're using an Access database or an Access project.
Views can also reference functions and other views.
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 WITH CHECK OPTION in this case should deny the entry of any NULL values in the view's AGE column, because the view is defined by data that does not have a NULL value in the AGE column.In SQL, a view is a virtual table based on the result-set of an SQL statement.