InstantForum.NET v4.1.4FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionalshttp://www.franklinfaces.com/no-reply@FranklinFaces.comSat, 31 Jul 2010 07:33:08 GMT20http://www.franklinfaces.com/Topic174-4-1.aspxNow, lets see how XML can directly be produced from SQL Server instead of the usual approach of serializing the entity classes in .Net. The benefits out of this will be:<br><br> 1.<br><br> Eliminate N number of round trips to the Database Server.<br> 2.<br><br> The cost involved in serializing the entity classes.<br> 3.<br><br> Ability to modify just the routine if at all any modifications are desired.<br><br>This article aims at explaining how can one generate XML out to SQL Server. Now, once the XML is out if the technology is either .NET or any other technology the same can be consumed with ease.<br><br>Wasting no more time, lets get into how this can be achieved.<br><br>Code<br><br>#1. Generates specific columns from the orders and ordersplits table.<br><br>Select (Select Orders.OrderId, OrderSplits.OrderSplitId, OrderSplits.SplitNumber from Orders Inner Join OrderSplits on Orders.OrderId = OrderSplits.OrderId where OrderSplits.OrderSplitId=11111 Order By Orders.OrderId, OrderSplits.SplitNumber FOR XML AUTO, ELEMENTS XSINIL)<br><br> <br><br>#2. Generates all columns in the output from the orders and ordersplits tables.<br><br>Select (Select Orders.*, OrderSplits.* from Orders Inner Join OrderSplits on Orders.OrderId = OrderSplits.OrderId where OrderSplits.OrderSplitId=11111 Order By Orders.OrderId, OrderSplits.SplitNumber FOR XML AUTO, ELEMENTS XSINIL)<br><br>Fri, 19 Feb 2010 03:21:15 GMTdebrah.h48http://www.franklinfaces.com/Topic174-4-1.aspxThis article describes how to generate XML string from relational database tables. <br><br>http://www.dotnetfunda.com/articles/article119.aspxFri, 15 Jan 2010 06:44:13 GMTdebrah.h48http://www.franklinfaces.com/Topic174-4-1.aspx[b]How to create auto number in xml database?[/b]<BR><BR><BR><BR><BR><BR>Sat, 02 Jan 2010 04:19:51 GMTtechnowizpvtltd