Stored Procedure Generator 1.0.0.0

Stored Procedure Generator 1.0.0.0

Creates 30 types of CRUD SP with JOIN & much more


Stored procedures provide the ability to perform some action against a database and have some advantages to query data from an application. First and foremost, it reduces the amount of redundancy and has a performance gain when multiple calls are executed.

For most applications, these stored procedures follow the same basic design whereby you list every field that you need to retrieve or save. For large tables or a large number of tables, writing these stored procedures can be very cumbersome and prone to typographical errors.

Stored Procedure Generator is a powerful tool designed for developers and is entirely built in C#.NET 2.0. This tool looks interesting for developers who develop and build information systems, web applications, or windows programmers who create compelling stored procedures. Generating these stored procedures is exactly what Stored Procedure Generator does on behalf of you.

Stored Procedure Generator supports MS SQL Server 2000, 2005, 2008 Databases. T4S Stored Procedure Generator provides the support of generating Select, Insert, Update and Delete. You can choose the name of stored procedure to be generated.

Providing you with powerful tool is our goal. So you aren't only able to generate stored procedures but also you can select the desired fields that will be affected by stored procedures. Performance is one of our main objectives in our tool. So you will be able to generate as much stored procedures as you need in no time.
Here are some key features of "Stored Procedure Generator":

· 30 types of SPs can be generated
· Save & reload project
· Various options for SP body formatting
· Flexible SP naming convention
· SQL Server 2000,2005,2008 compatible
· Various SP generation options like generate SP in single file, table wise files, operation wise files
· Paging SP generation like select paging, select first record, select previous record, select next record, select last record
· Recursive SP generation like select in hierarchy for SQL server 2005 and higher version
· Support for dynamic SPs like SelectByWhereConditionOrderBy
· Quick SP generation of Insert, UpdateByPK, DeleteByPK, SelectByPK, SelectAll, SelectViewByPK, SelectComboBox SP
· Shortcut in SQL server for quick access

Select SP Features:
· Joined SP generation
· Auto selection of join type (left outer join, inner join)
· Table wise foreign key column selection on which you want to perform join
· Table wise column selection which you want to display when that particular table is referenced.
· Table wise column selection for order by clause
· Operator selection based on column data type for SelectByColumnName SP like between operator for datetime data type, like operator for string data types.

Insert/Update/Delete SP Features:
· Error logging
· Concurrency validation based on selected columns in update, delete sp
· Error handling with & without try - catch
· Transaction Commit – Rollback
· Various options to set primary key value
· Various options to return primary key value
· Various options for column default assignment
· Time logging for SP execution

Requirements:

· Pentium 4 or later
· 4 GB Harddisk or more

Limitations:

· Allows to generate stored procedure for the tables having less than 25 columns



Developer:

License / Price:

Size / OS:

Last Updated:

Category:
Tools4SQL.net 
Demo / USD 100.00
8.3 MB / Windows XP / 2003 / Vista / 7
July 14th, 2010
Utilities


Click To Download
Stored Procedure Generator 1.0.0.0