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]
validation DBCC operations 2nd values putting into variables 2nd 3rd 4th 5th VAR() function 2nd varbinary data type varchar data type variables 2nd 3rd declaring 2nd global variables 2nd 3rd 4th 5th 6th 7th 8th @@ROWCOUNT 2nd user options 2nd naming 2nd of type table and temporary tables putting values into 2nd 3rd 4th 5th scopes 2nd types of 2nd 3rd VARP() function 2nd veritcally filtered versions of SQL Server 2000 Developer Edition Enterprise Edition Enterprise Evaluation Edition Personal Edition Standard Edition Windows CE Edition vertical partitioning 2nd vertically filtered very large database applications client/server model viewing lock behaviors with Enterprise Manager SQL server debugging information triggers 2nd 3rd 4th 5th views 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th access permission accessing 2nd 3rd 4th adding data through 2nd 3rd advantages of altering dropping 2nd 3rd editing 2nd 3rd 4th renaming 2nd benefits of 2nd 3rd columns selecting 2nd 3rd 4th 5th controlling data access granting permissions and ownership chains 2nd 3rd creating 2nd 3rd with Create View Wizard 2nd 3rd creating guidelines 2nd 3rd data modification constraining deleting rows 2nd 3rd 4th dropping 2nd 3rd editing 2nd 3rd 4th enhancing with aggregates 2nd with joins 2nd 3rd with views 2nd 3rd 4th granting permissions 2nd 3rd indexed 2nd 3rd indexed views 2nd 3rd 4th 5th 6th requirements for 2nd inserting rows 2nd 3rd 4th 5th modifying data 2nd deleting rows 2nd 3rd 4th inserting rows 2nd 3rd 4th 5th updating rows 2nd 3rd 4th optimizing performance ownership chains 2nd 3rd broken ownership chains 2nd 3rd 4th partitioned 2nd 3rd 4th federations partitioned views 2nd partitioned views. [See partitioned views] rows selecting 2nd 3rd 4th updating rows 2nd 3rd 4th Visio database design software VUE (Virtual University Enterprises)
|