SQL SP GENERATOR SNAPSHOT
SQL SP Generator is aSQL Stored Procedure Generator add-in for SQL Server Management Studio.
Benefits of using SQL SP Generator
· Completely Integrated with SQL Server Management Studio
· Easy to use step by step Wizard to generate Stored Procedures.
· Allows Stored Procedure generation using the following options:
o To SQL File with Unicode or ANSI format.
o Copy to Clipboard
o Copy to New Query Editor Window.
· Allows assignment of Standards to generate the stored procedure name. The standards that can be defined are procedure prefix / suffix and action specific prefix / suffix.
· The application saves your preferences, so the next time you open the wizard your settings will be pre-loaded.
· Assign permissions to different users or roles. The permissions that can be assigned are Alter, Control, Execute, Take Ownership and View Definitions.
· Creates the Drop Procedure script.
· Generates error handling script for Insert, Update and Delete procedures.