tag:blogger.com,1999:blog-4256538220587857609.post73235147608981188..comments2014-04-01T07:02:35.174-07:00Comments on Explore C# and C++ Programming Tips and Tricks: SQL Server 2008 : FOR XML RAWAnugrah Ahttp://www.blogger.com/profile/03242166038964647046noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4256538220587857609.post-78239677874723349532014-04-01T07:02:35.174-07:002014-04-01T07:02:35.174-07:00Here is more to rename the XML Nodes for ROOT &...Here is more to rename the XML Nodes for ROOT & ROWS<br /><br />Select LoadID As ShipmentID, CarrierID as Carrier from tblLoad FOR XML <b>RAW('Shipment')</b>, ELEMENTS, <b>ROOT('Shipments')</b>Anugrah Ahttps://www.blogger.com/profile/03242166038964647046noreply@blogger.comtag:blogger.com,1999:blog-4256538220587857609.post-91389348975804695962011-08-31T23:07:43.615-07:002011-08-31T23:07:43.615-07:00I thought that this is a new feature in SQL Server...I thought that this is a new feature in SQL Server 2008. but when i discussed this with a friend, i came to know that this feature exists from SQL Server2000 onwards. i verified his statement and he was correct :)Anugrah Ahttps://www.blogger.com/profile/03242166038964647046noreply@blogger.com