SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Samardeep Khera / Automatic Generation of Insert, Update and Delete stored procedures / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:47:32 GMT20RE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxHow can I do the same thing for all user database without running this script for all database one by one ?I am looking for a way to do it by one script only, then less human error.Wed, 17 Mar 2010 23:27:46 GMTmarrowyung-701823RE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxjust put print statements after creation of every SP so that u can know which part is causing the problem..or post your script..Tue, 03 Nov 2009 22:00:26 GMTSAMARDEEPRE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspx[quote][b]DWIGHT RUTLEDGE (8/13/2009)[/b][hr]I had to also do the replacement for spaces. However, I have a weird issue. I copied it into one database and it works great. However, I put it into another database it just returns that command(s) completed successfully but there are not procs created. Both databases are SQL 2008 standard.[/quote]I have the same issue - no procs created (sqlserver express 2008)Tue, 03 Nov 2009 17:19:46 GMTlukas-311170RE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxWhy do you use ALTER instead of CREATE when you create the Stored Procedures? I have enabled the Print option to see that it is you use the actually create the SP, then I copy what gets printed and execute it and SQL 2005 complains but if I change ALTER to CREATE I get past that issue.Fri, 14 Aug 2009 14:39:49 GMTpaul.m.cohenRE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxHI..Just try to debug it and see where the problem is..there may be a problem with compatible data type..and if it is then you can easily resolve it..Regards..Thu, 13 Aug 2009 23:18:06 GMTSAMARDEEPRE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxI had to also do the replacement for spaces. However, I have a weird issue. I copied it into one database and it works great. However, I put it into another database it just returns that command(s) completed successfully but there are not procs created. Both databases are SQL 2008 standard.Thu, 13 Aug 2009 16:44:23 GMTDWIGHT RUTLEDGERE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxHi paul..Thanks for the "timestamp" issue..would rectify it soonRegardsWed, 12 Aug 2009 23:19:42 GMTSAMARDEEPRE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxHi..Thanks for bringing this in notice..actually this is a browser problem and i'd try to rectify it in next post..ThanksWed, 12 Aug 2009 23:18:01 GMTSAMARDEEPRE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxThe routine does not work for "timestamp" columns. I get three errors one for each procedure that is being created. Had the same problem with "3f" character except my browser showed them as spaces but Visual Studio did not understand them at all and gave a useless error message.PS Thanks for the routine, it will be extremely useful.Wed, 12 Aug 2009 12:19:48 GMTpaul.m.cohenRE: Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxI had to replace x'3f' with spaces globally before the code would parse. These showed up as squares in my browser.Wed, 12 Aug 2009 09:45:37 GMTpaul price-200520Automatic Generation of Insert, Update and Delete stored procedureshttp://www.sqlservercentral.com/Forums/Topic760295-1606-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Stored+procedure+generation/67630/">Automatic Generation of Insert, Update and Delete stored procedures</A>[/B]Mon, 27 Jul 2009 12:41:04 GMTSAMARDEEP