Tag Archives: stored procedure

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 … Continue reading

Posted in database, db2, how to | Tagged , , , , , , , , , , , , , , , | Leave a comment

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 … Continue reading

Posted in db2, how to | Tagged , , , , , , , , , , , | Leave a comment

Stored Proc for SQL Server and DB2 UDB

We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a quick stored procedure that will take couple of input parameter and run the grant against the tables.  Just for the … Continue reading

Posted in database, db2, sql server | Tagged , , , , , , , , , | Leave a comment