Microsoft® SQL Server® 2012 Bible

327 Chapter 13: Working with Hierarchies 13 13 0x5AE368 4 Janice Galvin 14 0x5AE5 3 Michael Sullivan 15 0x5AE7 3 Sharon Salavari ...

328 Part III: Advanced T-SQL Data Types Querying Techniques 17 0x6AC0 /2/1/ 2 Kevin Brown 18 0x6B40 /2/2/ 2 John Wood 19 0x6BC0 ...

329 Chapter 13: Working with Hierarchies 13 DECLARE @EmpNode HierarchyID SELECT @EmpNode = OrganizationNode FROM HumanResources. ...

330 Part III: Advanced T-SQL Data Types Querying Techniques What you see is that the results show everyone who is a descendant o ...

331 Chapter 13: Working with Hierarchies 13 SELECT @EmpNode = OrganizationNode FROM HumanResources.Employee WHERE OrganizationNo ...

332 Part III: Advanced T-SQL Data Types Querying Techniques DECLARE @CurrentEmployee hierarchyid SELECT @CurrentEmployee = Organ ...

333 Chapter 13: Working with Hierarchies 13 One of the diffi culties when dealing with hierarchical data is that as it grows it ...

334 Part III: Advanced T-SQL Data Types Querying Techniques Indexing Strategies There are two approaches when needing to index h ...

335 Chapter 13: Working with Hierarchies 13 CTEs can be self-referencing, enabling it to be referenced multiple times in the sam ...

336 Part III: Advanced T-SQL Data Types Querying Techniques 6 269 Marketing Assistant 2 6 271 Marketing Specialist 2 6 272 Marke ...

337 Chapter 13: Working with Hierarchies 13 Although you can’t write a simple query to retrieve XML from hierarchyid data, there ...

c13.indd 338c13.indd 338 7/30/2012 4:47:06 PM7/30/2012 4:47:06 PM http://www.it-ebooks.info ...

339 CHAPTER 14 Using XML Data IN THIS CHAPTER Understanding The XML Data Type Using The XML Data Type Methods Working With The F ...

340 Part III: Advanced T-SQL Data Types and Querying Techniques What’s New with XML in SQL Server 2012 SQL Server 2012 didn’t ad ...

341 Chapter 14: Using XML Data 14 Querying XML wasn’t a walk in the park either, in the beginning. The same XML API’s that were ...

342 Part III: Advanced T-SQL Data Types and Querying Techniques ■ (^) Elements in your XML need to follow a certain order (First ...

343 Chapter 14: Using XML Data 14 GO CREATE TABLE [dbo].[Customer]( [CustomerID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar] ...

344 Part III: Advanced T-SQL Data Types and Querying Techniques INSERT [dbo].[Item] ([ItemID], [ItemNumber], [ItemDescription]) ...

345 Chapter 14: Using XML Data 14 ( [OrderDetailID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = O ...

346 Part III: Advanced T-SQL Data Types and Querying Techniques SET @var = '<Root> <Junk1>Some Junk</Junk1> &l ...