Automatic Generation of Insert, Update and Delete stored procedures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Samardeep Khera » Automatic Generation of Insert, Update and...

11 posts, Page 1 of 2

1 2 »»

Automatic Generation of Insert, Update and Delete stored procedures

Rate Topic

Display Mode

Topic Options

Author

Message

SAMARDEEP

Posted Monday, July 27, 2009 12:41 PM

SSC 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

paul price-200520

Posted Wednesday, August 12, 2009 9:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 09, 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

paul.m.cohen

Posted Wednesday, August 12, 2009 12:19 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, January 02, 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

SAMARDEEP

Posted Wednesday, August 12, 2009 11:18 PM

SSC 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

SAMARDEEP

Posted Wednesday, August 12, 2009 11:19 PM

SSC 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

DWIGHT RUTLEDGE

Posted Thursday, August 13, 2009 4:44 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, August 01, 2012 1:10 PM
Points: 3, Visits: 41

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

SAMARDEEP

Posted Thursday, August 13, 2009 11:18 PM

SSC 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

paul.m.cohen

Posted Friday, August 14, 2009 2:39 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, January 02, 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