XACT_ABORT, error handling, 219–221, 224
XACT_STATE ( ), error handling, 224
XLOCK, locking hints, 260, 265
XML (eXtensible Markup Language)
case sensitivity of, 83
exercise generating XML, 92
modify method, 84
overview of, 5
returning data from queries as XML, 86–89
updating data using XML, 89
xml data type
methods, 83
query methods for, 81
SQL support for, 80
updating data in XML queries, 89
XML indexes
overview of, 469
primary XML indexes, 469
secondary XML indexes, 470
XML schema
storing XML schema information, 80
SMO for accessing XML schema collections, 145
XML Web Services
benefits of, 357
SQL Server 2005 and, 22
XMLA (XML for Analysis), 154
XmlReader object, ADOMD.NET, 158
XPs (extended stored procedures)
executing out of band, 426
procedures compared with, 433
XQuery
case sensitivity, 83
components of, 81
exercise writing XQuery expression, 91
parameters, 84–85
querying XML data in SQL Server 2005, 469
querying XML data with, 81–84