December 2007 - Posts

• 2008: Converting XML to HIERARCHYID

  While working on a new book, I have been experimenting with the new HIERARCHYID data type. And since I've seen comparisons drawn between using XML versus using HIERARCHYID to manage a hierarchy of data, I decided that it would likely be very useful if Read More... Posted Sunday, December 09, 2007 1:39 PM by Peter W. DeBetta | 4 Comments

• 2008: Row Constructor or Table-Valued Parameter

  Denis posted a follow-up to the posts by both Louis and me. However, I have to say that there is a better way to pass a bunch of data to a procedure. The following code is amended to include the table-valued parameter feature. --The Movie Table CREATE Read More... Posted Thursday, December 06, 2007 6:14 PM by Peter W. DeBetta | 12 Comments

• 2008: More Row Constructor Fun

  My esteemed colleague Louis Davidson just wrote about a new feature in SQL Server 2008 known as row constructors . I thought I'd follow up with some more fun usage of this cool feature. In addition to being used with an INSERT statement, you can also Read More... Posted Wednesday, December 05, 2007 10:32 PM by Peter W. DeBetta | 4 Comments