A construct that can temporarily hold values for use in a Transact-SQL batch.
view
A view is a relational database object that can be referenced and built by using SELECT statements to join data from one or more base tables. Views are similar to tables in that data can be retrieved and modified and indexes can be built.
