Microsoft® SQL Server® 2012 Bible

347 Chapter 14: Using XML Data 14 The great thing is that you don’t need to learn a new language because Microsoft has cre- ated ...

348 Part III: Advanced T-SQL Data Types and Querying Techniques CREATE XML SCHEMA COLLECTION OrderInfoSchemaCollection AS N'< ...

349 Chapter 14: Using XML Data 14 DELETE FROM ItemInfo GO Now go back and execute the ALTER statement again, and when applied su ...

350 Part III: Advanced T-SQL Data Types and Querying Techniques </Order>' INSERT INTO ItemInfo (OrderID, ItemData) VALUES ...

351 Chapter 14: Using XML Data 14 '<Order OrderID="1"> <Item> <ItemNumber>V001</ItemNumber> <Quantity ...

352 Part III: Advanced T-SQL Data Types and Querying Techniques CREATE PROCEDURE SampleProc2 ( @var xml (OrderInfoSchemaCollecti ...

353 Chapter 14: Using XML Data 14 XML Data Type Methods The XML data type supports a number of methods providing various operati ...

354 Part III: Advanced T-SQL Data Types and Querying Techniques XQuery expression and evaluates the expression to a single node. ...

355 Chapter 14: Using XML Data 14 The question from the preceding example is why CROSS APPLY is used. When working with XML colu ...

356 Part III: Advanced T-SQL Data Types and Querying Techniques directives to use, it doesn’t provide a lot of control over the ...

357 Chapter 14: Using XML Data 14 The XML AUTO clause is also smart enough to generate hierarchical XML based on queries that us ...

358 Part III: Advanced T-SQL Data Types and Querying Techniques <OrderNumber>10003</OrderNumber> <OrderDate>20 ...

359 Chapter 14: Using XML Data 14 <Customer> <Name>Adam</Name> </Customer> </Order> Raw FOR XML RA ...

360 Part III: Advanced T-SQL Data Types and Querying Techniques <row OrderNumber="10003" OrderDate="2011-06-17T00:00:00" Name ...

361 Chapter 14: Using XML Data 14 <Name>Adam</Name> </Order> </Orders> /* Explicit The EXPLICIT directiv ...

362 Part III: Advanced T-SQL Data Types and Querying Techniques /* <Orders> <Order OrderNumber="10001"> <Customer ...

363 Chapter 14: Using XML Data 14 Similar results can be achieved by using special column name indicators such as data() and tex ...

364 Part III: Advanced T-SQL Data Types and Querying Techniques You have seen XQuery used throughout this chapter; for example, ...

365 Chapter 14: Using XML Data 14 <ItemNumber>1008</ItemNumber> <ItemNumber>1009</ItemNumber> <ItemNu ...

c14.indd 366c14.indd 366 7/30/2012 4:49:04 PM7/30/2012 4:49:04 PM http://www.it-ebooks.info ...