BlastThroughLearning.com: SQL Server 2005 Phase III

[Nguyen Trung Hoa]

BlastThroughLearning.com: SQL Server 2005 Phase III

SQL Server 2005 Phase III
1.0 Modifying Data with Action Queries
1.1 The Five Types of Action Queries
2.0 Getting to Know the T-SQL Functions
2.1 The T-SQL Language
2.2 String Functions
2.3 Date and Time Functions
2.4 Working with NULLS
3.0 Working with SQL Server Views
3.1 Working with Views
3.2 Creating Views Using SQL Server Management Studio
3.3 Using T-SQL to Create a View
4.0 More About Views
4.1 Creating Views Based on Data from Multiple Tables
4.2 Working with Subquery of a View
4.3 Working with Outer Joins
4.4 The Top Syntax
4.5 Sorting Results of a View
4.6 User-Defined Functions
4.7 Security Benefit of a View
4.8 Updateability of View Results
4.9 Modifying a View
4.10 Renaming a View
4.11 Deleting a SQL Server View
4.12 Indexed Views
4.13 How to Design Your Indexes Efficiently

Code:



http://hotfile.com/list/651587/72daf66