Chapter 1 INTRODUCTION TO SQL SERVER 2000 17
Chapter 1 INTRODUCTION TO SQL SERVER 2000 17 gations. An indexed view provides for a technique where fast access to data is enabled (indexing), associated with data display definitions (views), and where the result set of the view is materialized and stored and indexed in the database. Indexed views are covered fully in Chapter 7. SQL Server 2000 introduces three new data types bigint, sql_variant, and table that are supported for variables and are the return types for user-defined functions. Data Types are covered in full in Chapter 2, Data Modeling. INSTEAD OF triggers are executed rather than the triggering action (for example, INSERT, UPDATE, DELETE). They can also be defined on views, in which case they greatly extend the types of updates a view can support. AFTER triggers fire after the triggering action. SQL Server 2000 introduces the capability to specify which AFTER triggers fire first and last. Triggers are covered fully in Chapter 8, Constraints, Defaults, and Triggers. Cascading actions enable you to control the actions SQL Server 2000 takes when deleting or changing data. If you attempt to update or delete a key to which existing foreign keys point, cascading actions will dictate the effects on the associated records. This is controlled by the new ON DELETE and ON UPDATE clauses in the REFERENCES clause of the CREATE TABLE and ALTER TABLE statements. Cascading Referential Integrity is covered fully in Chapter 3, Physical Database Design. SQL Server 2000 includes support for most collations supported in earlier versions of SQL Server, and introduces a new set of collations based on Windows collations. You can now specify collations at the database level or at the column level. Collations are covered fully in Chapter 3, Physical Database Design. SQL Server 2000 supports running multiple instances of the relational database engine on the same computer. Each computer can run one instance of the relational database engine from SQL Server version 6.5 or 7.0, along with one or more instances of the database engine from SQL Server 2000. Connecting to Multiple Instances of SQL Server is covered fully in Chapter 2, Data Modeling. SQL Server 2000 can partition tables horizontally across several servers, and define a distributed partitioned view on each member server so that it appears as if a full copy of the original table is stored on each server. Groups of servers running SQL Server that
For reliable and cheap web hosting services please check javaweb hosting website.