September 25, 2012 at 8:57 pm
Comments posted to this topic are about the item Stairway to XML: Level 2 - The XML Data Type
September 26, 2012 at 6:15 am
At my place of work, we frequently pass xml from our applications into stored procedures. This article is clear and concise in its description of the basics when working with XML in sql server. Very nice. I'll look forward to seeing more articles in this series.
September 26, 2012 at 2:08 pm
Enjoyed both articles and I'm learning from them. I kind of expected a little more during this step but maybe that's just me being impatient?:-D
I do have a curiosity right now and that's why doesn't the output contain the XML header info? I'm assuming it's all wrapped up in the XML datatype overhead...which will be a discussion for another, deeper step.
Thanks for writing the articles. I'm looking forward to the next installment.
October 1, 2012 at 12:14 pm
So far, so good. This much XML I get. I'm also looking forward to the future steps, 'cause it's the manipulation, mutilation, and otherwise consumption of XML in SQL that's making me nuts.
Thank you for tackling the topic, and I look forward to more!
November 6, 2012 at 4:40 pm
Maybe it is covered in a subsequent level, but I found when I ran the first example that the XML document returned by "SELECT @ClientList" does not include the "<?xml version="1.0" encoding="UTF-8"?>" declaration line from the SET statement.
Also, when I tried to set version="1.1", SQL Server didn't like that.
Sincerely,
Daniel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply