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 123»»»

Insert Update Stored Procedure for a table Expand / Collapse
Author
Message
Posted Thursday, October 11, 2007 5:25 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:47 AM
Points: 967, Visits: 450
Comments posted to this topic are about the item Insert Update Stored Procedure for a table

Prasad Bhogadi
www.inforaise.com
Post #409791
Posted Thursday, December 6, 2007 3:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 10:30 AM
Points: 231, Visits: 198
I try to execute the Script but I get a lot of errors
Post #430103
Posted Thursday, December 6, 2007 6:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:47 AM
Points: 967, Visits: 450
Can you please post what errors you are getting?

Thanks


Prasad Bhogadi
www.inforaise.com
Post #430149
Posted Thursday, December 6, 2007 7:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 10:30 AM
Points: 231, Visits: 198
Never mind it was some spaces that were created when I copy paste the code. I fixed and it works.
now another question when I run the stored procedure ( exec GenerateInsUpdateScript countries) isnt that suppose to generate another stored procedure and save to my database or it just display it to me????
Because It just display it to me.
Post #430164
Posted Thursday, December 6, 2007 7:12 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:47 AM
Points: 967, Visits: 450
It just generates the script as it is a generic script. You need to execute the script and it would create a stored procedure. I thought this is generic and based on the based on the requirements may need little customization. So just generating the script.

Thanks


Prasad Bhogadi
www.inforaise.com
Post #430174
Posted Thursday, December 6, 2007 7:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 10:30 AM
Points: 231, Visits: 198
I actually use the mygeneration tool to create insert,update,delete, loadbyprimarykey stored procedures which works fine But I thought to give a shot to this one
any how : good work
Post #430205
Posted Thursday, December 6, 2007 8:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:47 AM
Points: 967, Visits: 450
Thank You, thats a good idea I would probably create a tool which would automate creation of the Insert, Update, Select and Delete Stored Procedures.

Thanks


Prasad Bhogadi
www.inforaise.com
Post #430220
Posted Thursday, December 6, 2007 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 16, 2009 2:40 PM
Points: 4, Visits: 24
So simple and so useful. Thanks a lot!

Eros
Post #430398
Posted Thursday, January 10, 2008 1:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2008 9:40 AM
Points: 1, Visits: 2
Excellent Stored Proc! This will save me a ton of time!
Post #441414
Posted Wednesday, January 23, 2008 2:22 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134
hi,
its soo helpful script for me. so simple to run. really appreaciatable.

thx
sreejith
MCAD
Post #446636
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse