Data Points: SQL Server 2005 XML Support, Exception Handling, and More

摘要

SQL Server 2005 includes several important im-provements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run. DDL triggers are useful when tracking or securing the creation and modification of database objects or changes to the database server. Another of these new features involves exception handling, which has made a huge leap forward with the inclusion of TRY/CATCH blocks. Another set of new features surround the new XML datatype, which represents a huge step forward in managing XML data within enterprise applications that interact with SQL Server. Now XML documents or fragments can be stored within an XML column, bound to a schema, and queried using the XQuery syntax. This month I'll answer three interesting questions readers have sent me on these topics.