In Transact-SQL (T-SQL) a view allows us to create a virtual representation of table whose contents are defined by the query. The query that defines the view can be joined from one or more tables. Once a view is created we can be reference the view in the FROM clause of the query. This lab is divided into six exercises explaining how to create, modify, and encrypt a view and how to create partitioned and indexed view’s.

Subscribe to Download

File Size807.46 KB
Create DateSeptember 11, 2016
Last UpdatedSeptember 11, 2016
Working with NULL in SQL Server
User Defined Functions in SQL Server