Filter view « View « SQL Server / T-SQL Tutorial

16.6.Filter view
16.6.1.A script that creates a stored procedure as a filter-view
16.6.2.A SELECT statement that uses the BankersMin view with where clause
16.6.3.Use view to join four tables
16.6.4.Create the view that combines all sales tables with union
16.6.5.Create a view with outer join and full join