Raju Pillai's Blog – August 2012 Archive (2)

Retrieving data as XML using stored procedure

On a previous post I showed how to insert parent-child data from an XML document using stored procedure. Well here I am going to show how to retrieve data from a table as an XML document.  Using the table set of tables from the previous post lets retrieve all the order details for a given customer.  Here is a stored procedure that will take customer_id as an input and then return an xml document that has all the orders and…


Added by Raju Pillai on August 4, 2012 at 6:33am — No Comments

Stored Procedure to insert data to parent and child using XML

Couple of days back I wrote an article that showed how to quickly insert a child table with a  parent table having generated column. On this one I am going to show you how to insert data using XML as a value.  As my previous article show its easy to insert to child table , but you have to insert one row at a time. Well what if we have multiple child rows…


Added by Raju Pillai on August 4, 2012 at 6:31am — No Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service