Humprey Evangelista Cogay

My Programming Adventures

Stored Procedure Generator

Here's a tool that im using for some of my projects. What it does is it Automate the Generation of Stored Procedures for Your Database.

You just have to execute a querry like this

             EXEC pr__SYS_MakeUpdateRecordProc 'Order_Details', 1

and it will automatically generate a stored procedure for the table (Order_Details) you specified. The link below shows the original article and also includes the generation of SPs for the CRUD Operations. One requirement is, you got to have a primary key for the table you wish to use. You can also use this article as a stepping stone to code a more flexible application that generates SPs with more options.

Click the link below