Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Automatic Generation of Insert, Update and Delete stored procedures Expand / Collapse
Author
Message
Posted Monday, July 27, 2009 12:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 3:02 AM
Points: 31, Visits: 63
Comments posted to this topic are about the item Automatic Generation of Insert, Update and Delete stored procedures
Post #760295
Posted Wednesday, August 12, 2009 9:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 9, 2010 1:10 PM
Points: 6, Visits: 20
I had to replace x'3f' with spaces globally before the code would parse. These showed up as squares in my browser.
Post #769441
Posted Wednesday, August 12, 2009 12:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, January 2, 2011 2:58 PM
Points: 11, Visits: 10
The 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.
Post #769563
Posted Wednesday, August 12, 2009 11:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 3:02 AM
Points: 31, Visits: 63
Hi..

Thanks for bringing this in notice..actually this is a browser problem and i'd try to rectify it in next post..

Thanks
Post #769870
Posted Wednesday, August 12, 2009 11:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 3:02 AM
Points: 31, Visits: 63
Hi paul..

Thanks for the "timestamp" issue..would rectify it soon

Regards
Post #769871
Posted Thursday, August 13, 2009 4:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 4:35 PM
Points: 3, Visits: 42
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.
Post #770559
Posted Thursday, August 13, 2009 11:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 3:02 AM
Points: 31, Visits: 63
HI..

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..
Post #770684
Posted Friday, August 14, 2009 2:39 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, January 2, 2011 2:58 PM
Points: 11, Visits: 10
Why 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.

Post #771333
Posted Tuesday, November 3, 2009 5:19 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 5:01 AM
Points: 66, Visits: 105
DWIGHT RUTLEDGE (8/13/2009)
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.


I have the same issue - no procs created (sqlserver express 2008)
Post #813345
Posted Tuesday, November 3, 2009 10:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 3:02 AM
Points: 31, Visits: 63
just put print statements after creation of every SP so that u can know which part is causing the problem..

or post your script..
Post #813409
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse