For XML Data in Sql server




select * from Registration for XML path('Ourtage') ,Root('Registration') for XML

here Path is used as Key Of Xml Data mostly used in json....

Root Is table Name....


Comments