At my current job we depend a lot on stored procedures for
our web applications and sometimes it gets really boring when we have to write
and re-write stored procedures for different databases and tables as demands
increase. This pain has me looking for an easier and faster way to generate
standard stored procedures that would meet our database design specifications.
A few years back I stumbled on some source code developed by e Tek Global that
would create stored procedures, but there were some short comings with the
brilliant tool because I had to know and pass my parameters to make the procedures
usable since it did not have a front end GUI. With my hunger then to still make
my job easier I went Googling and bought a tool with a GUI but it still it had
its own issues.
A few days ago I received an email from e Tek Global
regarding a new SQL 2005 add-in tool to do a similar job as the one they had
developed previously. With the descriptions it looked attractive but I was not
sure if it would be good enough to replace what I had. I decided to give it a
try with the evaluation copy. I was amazed by what the tool could do despite
some features not being function on the evaluation copy. I was still able to
generate powerful, well designed stored procedures. So here I am giving you a
sneak peek into SQL SP Generator.