X


XDR (XML Data Reduced) schemas, generating, 154

XML bulk load feature, overview of, 156

XML catalog views, support for, 158

XML columns

creating XML indexes on, 150

storing XML data in, 143

XML data types. See also strongly typed XML data types

built-in methods for, 147–149

extracting scalar values from, 149

overview of, 142–143

support for, 7–8

using FOR XML clauses with, 151–153

using OPENXML with, 155

XML DML statements, using with XML data types, 148

XML documents

exporting Showplan results as, 42

modifying, 148

retrieving contents of, 148–149

XML (eXtensible Markup Language)

enhancements for Analysis Services, 157–158

support for, 142

XML indexes, overview of, 150–151. See also indexes

XML schemas, retrieving, 146–147

XML_SCHEMA_NAMESPACE function, example of, 146

XMLA (XML for Analysis), using with Analysis Services, 225–226, 234–235

XMLSCHEMA directive, generating XSD schemas with, 152–153

XPath language, web address for, 149

XQuery expressions, using with XML data types, 147–149

XQuery language, support for, 149

XSD schemas. See also schemas

associating with XML columns, 143

example of, 144

generating with XMLSCHEMA directive, 152–153

using with Notification Services, 112




Microsoft SQL Server 2005 New Features
Microsoft SQL Server 2005 New Features
ISBN: 0072227761
EAN: 2147483647
Year: 2005
Pages: 80
Authors: Michael Otey

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