how query an xml filed in sql?

• lia.asti

  Newbie

  Points: 6

  More actions

  March 31, 2011 at 4:44 am

  #248810

  Hello. Help me please!

  My sql table is here:

  CREATE TABLE MyTable(

  [ComputerName] [varchar](50) NULL,

  [AppInfo] [xml] NULL)

  and AppInfo column contains an info as:

  <ROOT>

  <OperatingSystem>Microsoft Windows XP Professional</OperatingSystem>

  <Applications>

  <Application>Applicazione 1</Application>

  <Application>Applicazione 2</Application>

  <Application>Applicazione 3</Application>

  <Application>Applicazione 4</Application>

  </Applications>

  </ROOT>

  I need obtain a list as:

  Applicazione 1

  Applicazione 2

  Applicazione 3

  Applicazione 4

  How can query the table?

• matzer

  SSCrazy Eights

  Points: 9727

  More actions

  March 31, 2011 at 5:30 am

  #1305903

  SELECT

  ComputerName,

  X.C.value('.', 'varchar(255)')

  FROM

  dbo.MyTable

  CROSS APPLY

  AppInfo.nodes('/ROOT/Applications/Application') as X(C)

• lia.asti

  Newbie

  Points: 6

  More actions

  March 31, 2011 at 7:04 am

  #1305942

  Thanks. What I need.

  Lia.