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