Don't you wish that there is a tool out there that will magically generate the Insert, Select, Update, and Delete stored procedure scripts for you by simply right-clicking on a database or table?
Look no further! EZStoredProc (pronounced as "Easy Stored Proc") is that magical tool. Unlike the clumsy wizard provided by MS SQL Server Enterprise Manager, EZStoredProc does not add a number to the end of every parameter of the generated stored procedure. It is a lot smarter in handling primary key, composite keys, and identity column. It does not generate a stored procedure that passes in duplicate parameters when you have both primary key and identity field as the same column. It is a lot more powerful and flexible because it provides many options for you to format and tweak your stored procedures.
Below are some of the highlights of EZStoredProc:
Simply right-click to generate stored procedures for databases and tables.
Execute stored procedure script against your database directly from EZStoredProc.
Option to use identity field and/or primary key fields in Where clause.
Generate Insert, Select, Update, and Delete stored procedures.
Generate "Grant Execute" statement for each stored procedure.
Return identity value (if identity field exists) from table.
Allow flexible formatting and naming of stored procedures.
Support either Windows Login or SQL Server Login.
Support composite primary keys.
Platform: Win2000,Win7 x32,Win7 x64,Win98,WinVista,WinVista x64,WinXP
Link to EZStoredProc sample code
License: Free To Try
Date Added: Oct 29, 2006
Last check for an update: May 25, 2017
Last version date: Jan 31, 2010
Page Visit: 104
Malware Status: Clean
Scan Date: Apr 12, 2008