SPGen Can generate the TSQL code for an INSERT or UPDATE SQL Stored Procedures
Download

SPGen Ranking & Summary

SPGen Tags

generator generate insert code Insert Embed Code BB code insert Insert AdSense Code Extract Stored Procedures generate SQL code generate TSQL code TSQL code generator SQL Stored Procedure TSQL code tsql generate stored procedures

SPGen Description

The SPGen application was developed to be a simple tool which can generate the TSQL code for an INSERT or UPDATE Microsoft SQL Stored Procedures. Point it at a table, click the generate button and the code is generated for you.Using the application:Extract the downloaded demo zip, or re-compile the project, and run the executable.- SPGen starts up and lists all locally registered SQL Servers in the top left drop down list - Select, or type in, the SQL Server you want to connect to - Enter in the User Name and Password for the SQL Server. If there is no Password needed then just leave the Password field untouched - Click the Connect button - SPGen will now attempt to connect to the specified SQL Server and list all the Databases - Once the Databases are listed, expand the Database you wish to work with SPGen will now list all the Tables within the expanded Database - Now expand the Table you wish to generate an SP for - There will be two options; UPDATE or INSERT. Click the one you want SPGen will now attempt to retrieve the columns for the Table (but not display them) and generate the specified SP type - Once generated the code is placed in the text box on the right and you can cut & paste that code into Microsoft SQL Enterprise Manager, or Microsoft SQL Server Query Analyzer That is the extent of SPGen's functionality. You can generate SPs for other Tables, without having to re-connect, or you can connect to another SQL Server and generate SPs for that.

SPGen Related Software