MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

‘ (double dash)  

named parameters   2nd  

naming

        variables   2nd  

naming conventions

       entities and attributes   2nd  

       four part names  

nchar data type  

nested queries

       derived tables   2nd  

       IN clauses   2nd  

nested stored procedures   2nd  

nested triggers   2nd   3rd  

       disabling  

new features

       for indexing  

NEWID() function  

nodes

       clustered indexes  

nonclustered covering indexes   2nd  

nonclustered indexes   2nd   3rd   4th   5th   6th   7th  

       creating

               using code   2nd  

       guidelines for   2nd  

normalization   2nd  

       first normal form   2nd  

       second normal form   2nd   3rd  

       third normal form   2nd   3rd   4th  

Northwind database  

NOT  

ntext

       placing into filegroups  

ntext data type  

NTFS partitions  

NULL  

null values

       data integrity  

NULL values

       filtering out   2nd   3rd   4th  

null values

       ordering  

numeric data types   2nd   3rd  

NUMERIC_ROUNDABORT database configuration option  

nvarchar data type  

Категории