As a database developer, coding the SELECT, UPDATE, INSERT, and DELETE (SUID) stored procedures for each table in your database can be tedious, boring, and time-consuming. For that reason, I created the procedure usp_GenerateProcsForTable, which automatically generates the basic SUID procedures for any given tablename passed in. Your table must have a primary key in order for this to work properly.
This tool is a huge timesaver for developers and DBAs.
The syntax is [EXEC] usp_GenerateProcsForTable [@table_name=] 'MyTable'.
If you want to go a step further and generate SUID procs for your entire database in one stroke........you can execute this proc via the system-supplied proc sp_MSForEachTable; i.e.,
sp_MSForEachTable 'usp_GenerateProcsForTable ''?'''
