Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Cade Bryant,
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 ''?'''
stored procedures in a database
Procedure to see database status
How to have a Stored Procedure work on another database
DATABASE NAME AS PARAMETER IN PROCEDURE
Search for a text in all the stored Procedures in a Database