This tool allows you to define and standardize your
procedure names and goes a step further to allow you to specify any keywords
that need to be removed from the Stored Procedure name. For example, you might
not want the prefix like "tbl" or "tlkp" in the procedure
names, you can specify those keywords in the Choose Options Window as shown
If you look at Figure 3, you can see that the tool allows
you to define the overall procedure prefix and suffix. For example, you can
define pr_ as your prefix, which will attach pr_ to every procedure that will
be generated. The Remove Keywords from Table allows you to define the words
that should be excluded from the procedure name.
The tool makes it even more procedure specific where you can
define the prefix and suffix for your Insert, Update, Delete, Get All and Get
Finally, the Choose Options step allows you to select
whether you would like to have error handling on your script, whether you want
to create Drop Script and also specify user permissions. The error handling
will include the Try Catch block that has been introduced in SQL Server 2005.
These steps make my coding life easier because all my
specified options are locally stored on my machine where it remembers my
settings next time I am using the tool.
This gives the tool a big plus over others in the market.