Table To Xml in Sql Server

SELECT
          Filed1 ,
          Filed2 ,,
          Company_ID ,
          Employee_ID
FROM    dbo.TableName  WITH (NOLOCK)
FOR
XML PATH('Node') ,
ROOT('Root')

Post a Comment

0 Comments