I got a stored procedure generator a few weeks ago. I evaluated several solutions & i came down to one that I liked best.
http://www.ivertech.com/ezStoredProc/default.aspxIts called EzStoredProcedure. Its pretty pimp for flat tables. My company has about 300 tables that map 1:1 with business objects. It spits out the repetative Create Read Update Delete stored procedures which allows me to get on with my code.
Its not fancy, it just does what it needs to do and cheaply & I like that a lot. I couldn't believe how expensive some programs are that do this. Its basically just reflecting strings from the database schema into a templated text file....
Labels: sql, stored procedure, t-sql