New SQL Server 2000 Features
What does SQL Server 2000 have to offer over SQL Server 7? The following is a list of the new features provided in SQL Server 2000:
User-defined functions
Indexed views
Distributed partitioned views
INSTEAD OF and AFTER triggers
New datatypes
Cascading RI constraints
Multiple SQL Server instances
XML support
Log shipping
The rest of this section takes a closer look at each of these new features and provides a reference to subsequent chapters where more information about the new feature can be found.
User-Defined Functions
SQL Server has always provided the ability to store and execute SQL code routines via stored procedures. In addition, SQL Server has always supplied a number of built-in functions. Functions can be used ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
