Datasheet
Automated certificate creation for SSL
In SQL Server 2000, when using Secure Sockets Layer (SSL) to log in to a SQL
Server instance, you had to manually create a certificate to underpin the use
of SSL. SQL Server 2005 creates a certificate automatically. That allows you to
use SSL without manually creating a certificate.
Transact-SQL Enhancements
SQL Server 2005 has added several new features to Transact-SQL.
Transact-SQL is the version of the Structured Query Language (SQL) used by
SQL Server 2005. Transact-SQL is often abbreviated to T-SQL. T-SQL has many
features, which are not included in ANSI SQL.
Improved XML support
SQL Server 2000 allowed you to retrieve relational data as XML with the FOR
XML clause or store XML as relational data in SQL Server, using the OPEN XML
clause. SQL Server 2005 has a new xml datatype that allows you to write
code to retrieve XML data as XML, avoiding the transformation from XML to
relational data that occurred when using OPEN XML. You can also use a
schema document expressed in the W3C XML Schema Definition language
(sometimes called XSD schema) to specify allowed structures in the XML.
Note: Strictly speaking, the xml datatype stores data in a proprietary binary
format. For practical purposes, you can retrieve and manipulate the data
as XML.
The xml datatype supports several keywords in T-SQL. I show you how to
use these keywords in Chapter 7.
Error handling
SQL Server 2005 allows you to use TRY ... CATCH blocks in your T-SQL
code. So, if your code causes an error, the code in the CATCH block allows
you to specify what to do when an error occurs. I show you how to use
TRY ... CATCH blocks in Chapter 10.
23
Chapter 2: New Features in SQL Server 2005
06_577557 ch02.qxp 12/20/05 9:43 PM Page 23