Softworkbench.SPGenerator

Softworkbench.SPGenerator is a stored procedure generator that supports Microsoft SQL Server and Oracle. Softworkbench.SPGenerator will process each table and view in the database which you selected and created stored procedures to insert, update, delete, select (single or multiple records) using the fields you choose as well as using stored procedure name you desire.

Softworkbench.SPGenerator Stored Procedures Generator offers:

1.Generate stored procedures to insert data rows and return identity id for SQL server and sequence number for Oracle. 2.Generate stored procedures to select, update, delete single data row based on primary key definitions. 3.Generate stored procedures to select all rows based on foreign key definitions. 4.Generate stored procedures to select all rows of tables and views. 5.Generate one big sql script file or each file per table 6.Control output stored procedures format in runtime by modifying XSL style sheet. Control output stored procedure's name and columns in the run-time. 7.Generate package header and body for Oracle. 8.Support composite primary key

Database supported by Softworkbench.SPGenerator Stored Procedures Generator

1.SQL Server 2.Oracle