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

Creating Functions for Stored Procedures Expand / Collapse
Author
Message
Posted Friday, October 10, 2008 12:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 16, 2014 10:56 AM
Points: 27, Visits: 300
Comments posted to this topic are about the item Creating Functions for Stored Procedures
Post #583773
Posted Friday, October 10, 2008 3:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 10, 2009 12:04 PM
Points: 27, Visits: 90
the C# link is broken ... however ... I was able to download the VB code
Post #583827
Posted Friday, October 10, 2008 3:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 4:59 AM
Points: 9, Visits: 10
I wanted to know how it was done in c# but the link is broken.
Post #583829
Posted Friday, October 10, 2008 4:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 3:28 AM
Points: 24, Visits: 277
I have script that generate DML stored procs for all tables. This will help me generate even more code, if only the C# script is available. Please fix the link
Post #583851
Posted Friday, October 10, 2008 5:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 5:45 AM
Points: 2, Visits: 23
The link for C# TSQL script is http://www.sqlservercentral.com/Files/CreateADO_Call_BySPName_Cs_GetFile.sql/1788.sql.
Post #583872
Posted Friday, October 10, 2008 5:09 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 5,338, Visits: 1,385
I am getting the following error while accessing the C# code:

The resource could not be found
Sorry, we could not find the resource at http://www.sqlservercentral.com:80/Files/CreateADO_Call_BySPName_C

If problems persist, please contact us to let us know.



Post #583874
Posted Friday, October 10, 2008 5:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 2,668, Visits: 19,229
Just curious, if you are working in an environment where DBA's DON'T know not to use sp_, is there another way to filter out the system procs and keep the rest? SQL Server doesn't hold onto a createid, does it?

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #583875
Posted Friday, October 10, 2008 5:11 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 5,338, Visits: 1,385
Marcelo Luiz Soares de Souza (10/10/2008)
The link for C# TSQL script is http://www.sqlservercentral.com/Files/CreateADO_Call_BySPName_Cs_GetFile.sql/1788.sql.


Thanks I got the code. I didn't saw this link while posting the earlier message. Please rectify this in the article also. :)



Post #583876
Posted Friday, October 10, 2008 6:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:52 AM
Points: 17, Visits: 45
Alex,

This is AWESOME. This is going to save me a heap of time. Thanks a million for sharing.

-Barry
Post #583891
Posted Friday, October 10, 2008 6:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 16, 2014 10:56 AM
Points: 27, Visits: 300
Believe it on not – I did. This is was while ago, but when I joined to project, all sprocs named as SP_. It took about a month to convince managers to stay out of prefix SP_.
Post #583897
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse