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]

unary operators   2nd  

UNION ALL   2nd  

UNION ALL statement  

UNION operator   2nd   3rd   4th   5th  

unique indexes   2nd   3rd  

uniquidentifier data type  

UPDAE STATISTICS   2nd  

UPDATE statements   2nd  

UPDATE STATISTICS   2nd   3rd  

UPDATE trigger

       creating

               with Enterprise Manager   2nd   3rd   4th  

UPDATE triggers   2nd  

updates

       to cursors

               prevening  

updating

       cursors   2nd  

       data   2nd   3rd  

               with cursors  

       immediate updating  

       rows

               through views   2nd   3rd   4th  

       statistics

               indexing  

       Subscribers  

               immediate updating   2nd   3rd  

               queued updating   2nd  

               remote agent activation   2nd  

user error messages   2nd  

USER NAME  

user options   2nd  

user roles  

       defining  

       fixed roles  

user-defined data types   2nd  

user-defined errors

       raising  

user-defined functions   2nd   3rd   4th   5th   6th   7th  

       altering  

       creating   2nd   3rd   4th   5th  

               inline user-defined functions   2nd   3rd  

               scalar functions  

               table-valued functions   2nd  

               with Enterprise Manager   2nd   3rd   4th  

       data

               filtering   2nd   3rd   4th  

       determinism   2nd   3rd  

       dropping  

       error handling   2nd   3rd   4th  

       inline table-valued functions  

       parameters

               passing and returning   2nd   3rd  

       procedural business logic

               enforcing   2nd  

       restrictions on   2nd  

       scalar functions  

       table-valued functions  

utilities   2nd  

       BCP  

       Books Online   2nd   3rd  

               Accessing and Changing Relational Data book  

               Administering SQL Server book  

               Analysis Services book  

               Building SQL Server Applications book  

               Contents tab  

               Creating and Maintaining Databases book  

               Creating and Using Data Warehouses book  

               Data Transformation Services book  

               English Query book  

               Getting Started book  

               Glossary  

               How-To book  

               Index tab  

               Installing SQL Server book  

               Meta Data Services book  

               Optimizing Database Performance book  

               Replication book  

               Search tab  

               Transact-SQL reference  

               Troubleshooting book  

               Using SQL Server Tool book  

               What's New? book  

               XML and Internet Support book  

       Bulk Copy program  

       Client Network utility   2nd   3rd   4th  

               Alias tab  

               DB-Library tab  

               General tab  

               Network Libraries tab  

       Enterprise Manager   2nd   3rd  

               registering servers   2nd  

       Enterprise Manager Console (EMC)  

               configuring   2nd  

       OSQL  

       Profiler   2nd  

       Server Network utility  

       Service Manager   2nd   3rd  

Категории