Identify the appropriate uses for the different types of constraints. Select specific rows based on specific operators. Manipulate character, numeric, and date data by using TSQL functions. Use wildcards to retrieve rows. Format and sort query results.
Indexes Identify appropriate uses of indexing.
Differentiate between clustered and nonclustered indexes. Create unique and composite indexes. Identify performance considerations when using indexes. Use index management options. Copyright 1997 FirstClass Systems Corporation.