Where to start to learn XML with SQL Server

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  November 11, 2013 at 8:58 pm

  #282440

  Hi Floks,

  I am trying to get my hands dirty with XML in SQL Server. I have tried MSDN and some other links which google suggested but i think they are far from being from basic.

  Can you guys please suggest some links to start with.

  Thanks

• Alan Burstein

  SSC Guru

  Points: 61136

  More actions

  November 12, 2013 at 7:51 am

  #1665733

  Shadab Shah (11/11/2013)

  ---

  Hi Floks,

  I am trying to get my hands dirty with XML in SQL Server. I have tried MSDN and some other links which google suggested but i think they are far from being from basic.

  Can you guys please suggest some links to start with.

  Thanks

  Robert sheldon's Stairway to XML[/url] is simple yet very good.

  You can also look at the W3Schools XML Tutorial,

  andW3Schools XPath Tutorial for a simple & informative XML overview. This is also good: xml Data Type Methods (Technet).

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001

• Jeff Moden

  SSC Guru

  Points: 1003851

  More actions

  November 12, 2013 at 8:26 am

  #1665744

  Shadab Shah (11/11/2013)

  ---

  Hi Floks,

  I am trying to get my hands dirty with XML in SQL Server. I have tried MSDN and some other links which google suggested but i think they are far from being from basic.

  Can you guys please suggest some links to start with.

  Thanks

  The most important lesson that I've learned about XML is that it doesn't even meet the requirements of First Normal Form. Except for storing original XML data in an audit table (and I'd rather not do even that), I try to avoid letting anyone store XML data on any server that I'm responsible for. I don't even like to use it for "configuration control" in SQL Server even though the folks that have written various features of SQL Server are unfortunately leaning in that direction.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)