PLEASE NOTE: THIS IS THE OLD VERSION
THE NEW VERSION IS HERE
All you have to do is change the @tablename and @authorname parameters and use the resulting code.
i have included the primary key in the insert and update statements even though it is not valid.
the code generated is meant to be used as a template to create your actual production SP's
please refer to http://www.sqlservercentral.com/scripts/AutoGenerate++++++parameters/64760/ for the updated version
have fun
Chris Morton cbmorton [AT{ [gmail( . dot . } com ))]