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 «««12345

Dynamic creation of Insert, Update, Delete Stored procedure Expand / Collapse
Author
Message
Posted Sunday, July 11, 2010 11:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 12:27 PM
Points: 224, Visits: 145
Hi

Great effort in getting out this procedure but what about decimal(p,s) that doesn't seem to reflect either.

Post #950493
Posted Sunday, July 11, 2010 12:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 3:01 AM
Points: 14, Visits: 56
You could try this forum link:
http://www.sqlservercentral.com/Forums/Topic892846-391-1.aspx#bm901179
Regards
Post #950502
Posted Wednesday, July 14, 2010 12:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 16, 2011 5:47 PM
Points: 2, Visits: 22
This is AWESOME! Thank you!
Post #952629
Posted Thursday, July 15, 2010 7:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 9:15 AM
Points: 35, Visits: 84
to check your decimal(p,s) you can do this :



 Case	When  systypes.xusertype =106 Then '(' + Convert(varchar(10),syscolumns.xprec) +','+Convert(varchar(10),syscolumns.xscale)+')' 

Post #953101
Posted Saturday, July 24, 2010 9:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 3:01 AM
Points: 14, Visits: 56
Eric_AZ (7/14/2010)
This is AWESOME! Thank you!

Hi,
Just wondering if you mean the SSCodeGen software to generate code, from the forum link before your reply, or this article for dynamic sql?
Post #958403
Posted Monday, July 26, 2010 3:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 3:01 AM
Points: 14, Visits: 56
Hi,

For download and information on the code generating software for Sql Server 2005/2008, you can now visit http://www.raisintech.com/SSCodeGen/tabid/87/Default.aspx. The link for the version to work with Sql Server 7 and 2000 is at this URL as well.
Regards
Post #958668
Posted Friday, June 03, 2011 1:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 06, 2013 10:29 AM
Points: 6, Visits: 15
I just want to thank you very much for relieving HOURS of tedium! Even if I have to tweak it a bit (for example, on my updates I add ISNULL(@NewValue,[OldValue]) to the statements so I can do a partial update if I like) I will benefit greatly. I was growing old copying and pasting and typing just to get the procs inplace so I could get to the coding, which is using Entity framework. This really needed doing.

Lisa Z. Morgan
Post #1119663
Posted Monday, July 22, 2013 9:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:56 AM
Points: 2, Visits: 8
Thank for share. It is very useful for the developers. But I can not use with column ID has data type is nvarchar(20). Please, help me. Thank you!
Post #1476334
Posted Tuesday, July 23, 2013 6:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 3:01 AM
Points: 14, Visits: 56
Sorry, I can't help as I haven't worked on this for a couple of years, and haven't got the time to get back into it.
Post #1476546
Posted Tuesday, July 23, 2013 7:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:56 AM
Points: 2, Visits: 8
anthonyh (7/23/2013)
Sorry, I can't help as I haven't worked on this for a couple of years, and haven't got the time to get back into it.


Thank you.
Post #1476853
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse