SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 
        
Home       Members    Calendar    Who's On


12»»

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 6:00 AM
Points: 16, Visits: 53
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: Wednesday, January 21, 2009 7:47 AM
Points: 1, Visits: 6
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 06, 2009 3:30 AM
Points: 9, Visits: 37
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: Monday, January 12, 2009 9:25 AM
Points: 2, Visits: 16
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
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 02, 2009 9:26 AM
Points: 3,280, Visits: 962
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


SSC Eights!

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

Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 811, Visits: 2,149
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?

---------------------------------------------------------

For Best Practices on posting questions that get answered quickly, see http://www.sqlservercentral.com/articles/Best+Practices/61537/
and
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #583875
Posted Friday, October 10, 2008 5:11 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 02, 2009 9:26 AM
Points: 3,280, Visits: 962
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 24, 2009 7:20 AM
Points: 9, Visits: 12
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 6:00 AM
Points: 16, Visits: 53
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 »

12»»

Permissions Expand / Collapse