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.
Lattice.SPGen Stored Procedure and Code Generator Lattice.SPGen is a stored procedure and code (C# and VB.NET) generator wizard that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, MySQL and PostgreSQL.
ADO.NET Express Pro ADO.NET Express is an add-in for Visual Studio 2003 that generates class methods for calling stored procedures and executing common types of SQL statements. It supports C#/VB and SQL Server/Oracle.
EazySQL Generates ready to use SELECT, INSERT, UPDATE, DELETE and VIEW SQL Statements and SQL Stored Procedures from table structures of MS SQL Server 2000 and 2005. Supports Optimistic Concurrency Control for Update, Foreign-Keys, etc.
Extended Stored Procedure component Write Extended Stored Procs for SQL Server with ease:
* Control over input/output procedure parameters.
* Return an arbitrary number of recordsets.
* Real world code: work as a part of the complex accounting system, 7x24.
DecryptSQL Do you have such kind experience that you can not view the complete SQL Script because of the reason with "WITH ENCRYPTION" when you view the Stored Procedure, View, Trigger and Function of MS SQL SERVER? If yes, the DecrypSQL can help you.
Kickstart Kickstart lets you write scripts using a simple Basic like language to generate database objects in any language for every table in a Database schema. Update schemas using a built in ERD diagram. Compare schemas using the database compare tool.
Visual SQL-Designer Light Visual SQL-Designer Light is a program for easy visual constructing hard SQL-query for any database and write it. Support MSSQL 6.5-7.0-2000, MSAccess and other ODBC databases. Union query builder.Stored Procedure wizard.
SqlSpec Given one or more connection strings to SQL Server, Oracle, DB2, MySQL, PostgreSQL, Analysis Server, or Access databases, SqlSpec will generate documentation about all the objects in your database.
FastQuery for SQL Server Are you tired of using Enterprise Manager to connect to remote SQL Server databases, and finding it is unbearably slow? Look no further!!
DbObjFind 1.0 It finds text in all stored procedures and functions of a SQL Server database, and displays the matching lines, highlights the search phrase. It allows to jump to the selected line with one click. Most of SQL Server management tools can't do this.
SQLHelp Annotate and document the SQL stored procedures driving your web application. SQLHelp describes the parameters, output result sets and transactional nature of each procedure. Output options include colorized SQL listings.
