Dynamic creation of Insert, Update, Delete Stored procedure

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 Deepthi Viswanathan... » Dynamic creation of Insert, Update, Delete...

47 posts, Page 5 of 5

«««1 2 3 4 5

Dynamic creation of Insert, Update, Delete Stored procedure

Rate Topic

Display Mode

Topic Options

Author

Message

krishnavamshi24

Posted Sunday, July 11, 2010 11:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 9:00 AM
Points: 224, Visits: 141

Hi

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

Post #950493

anthonyh

Posted Sunday, July 11, 2010 12:22 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, June 04, 2011 4:49 AM
Points: 13, Visits: 53

You could try this forum link:
http://www.sqlservercentral.com/Forums/Topic892846-391-1.aspx#bm901179
Regards

Post #950502

Eric_AZ

Posted Wednesday, July 14, 2010 12:36 PM

Forum 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

R-CHERIF Ammar

Posted Thursday, July 15, 2010 7:10 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:28 AM
Points: 35, Visits: 80

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

anthonyh

Posted Saturday, July 24, 2010 9:46 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, June 04, 2011 4:49 AM
Points: 13, Visits: 53

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

anthonyh

Posted Monday, July 26, 2010 3:49 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, June 04, 2011 4:49 AM
Points: 13, Visits: 53

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

Lisa Z. Morgan

Posted Friday, June 03, 2011 1:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:23 AM
Points: 3, Visits: 10

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. Smile

Lisa Z. Morgan

Post #1119663

« Prev Topic | Next Topic »

47 posts, Page 5 of 5

«««1 2 3 4 5

Permissions