X


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




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net