Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft SQL Server 2008 R2 Unleashed- P91

Microsoft SQL Server 2008 R2 Unleashed- P91:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 844 CHAPTER 27 Creating and Managing Views in SQL Server adventure-works rachel0 1965-08-09 F 2003-07-01 1 Only the rows in the Employee table with a HireDate value greater than March 1 2003 are returned when you select everything from the view. Separate views can be created based on geography demographics or any other data element that requires a different set of security. Keep in mind that additional conditions can be applied when selecting from a view. You can utilize another WHERE clause in the SELECT statement that uses a view. This is demonstrated in the following example select from EmpViewHorizontal where HireDate 7 1 03 and BirthDate 1 1 65 LoginlD BirthDate Gender HireDate SalariedFlag adventure-works rachel0 1965-08-09 F 2003-07-01 1 As you can see a view with horizontal security restricts your initial result set but does not prevent you from applying additional conditions to obtain the desired result. Creating Views You can create several different types of views in SQL Server 2008 including standard views indexed views and partitioned views. Standard views are like those that have been discussed thus far in this chapter they let you achieve most of the benefits associated with views. An indexed view has a unique clustered index defined on it that causes the view to be materialized. In other words the creation of the index causes physical storage of the data related to the view s index. Partitioned views join horizontally partitioned data from a set of distinct tables. They can be locally partitioned meaning that the tables are on the same server or they can be distributed meaning that some of the tables exist on other servers. Partitioned views and indexed views are discussed in detail later in this chapter. All types of views share a common set of restrictions Every column including derived columns must have a name. The SELECT statement used in the view cannot include the COMPUTE BY clause or the INTO keyword. The SELECT statement used in the view .