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


Version1.0
Download5
File Size807.46 KB
Create DateSeptember 11, 2016
Last UpdatedSeptember 11, 2016