MS SQL Basics Tutorial: New features for SQL Server 2000

New features for 1.2 SQL Server 2000

SQL Server 2000 fully expands the performance reliability and ease of use of SQL Server 7.0 to make it an outstanding database platform for large online transaction processing data warehouses and E-commerce

The new features of SQL Server 2000 are mainly as follows:

1.2.1 Database Enhancements

SQL Server 2000 introduces database and server enhancements and some other new features

1 XML extensible Markup Language Extensible Markup Language support

The relational database engine can return XML document data XML data can be used to insert delete and update data XML is an Extensible Markup Language extensible Markup Language XML language can be used to describe the contents of a dataset and how the data is in the Web The page displays or outputs to a device XML and HTML hypertext Markup Language Hypertext Link Markup Language originates from SGML Standard general Markup Language standard Generic Markup Language SGML is a very complex and huge Language is hard to use when publishing data on the Web. HTML is much simpler and more specialized than SGML, but HTML has a certain amount of data to work with. It's simpler than SGML, but much more powerful than HTML, so XML becomes web An increasingly important language for electronic data exchange in a network or corporate intranet

SQL Server 2000 support for XML is shown in the following areas

.. Access to SQL Server via URL uniform Resource Locator Uniform Resource Location

.. Support Xml-data Mode

.. Can retrieve writing XML data

.. SQL Server OLE DB adds support for XML documents

2 New data type Types

3 types of data are added to SQL Server 2000 bigint sql_variant and table

3 Text type data in a data row

In SQL Server 2000, you can store text and image type data directly into a table's data row instead of to a different data page, which reduces the amount of I/O that is used to store the text and image types and correspondingly reduces the number of I/OS for disk processing data