Thursday 21 January 2016

Table To Xml in Sql Server

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

No comments:

Post a Comment

SqlDataBaseLibrary

using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using AOS.Repository.Infrastructure; using S...