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

Temporary Stored Procedures Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 10:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 16, 2014 2:48 PM
Points: 9, Visits: 435
Comments posted to this topic are about the item Temporary Stored Procedures
Post #1466970
Posted Tuesday, June 25, 2013 3:47 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: Friday, April 11, 2014 12:51 AM
Points: 974, Visits: 1,065
I always forget this feature :D
Post #1467056
Posted Tuesday, June 25, 2013 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:53 AM
Points: 7, Visits: 83
I always forget it too - but only at the end of the session
Post #1467076
Posted Tuesday, June 25, 2013 7:49 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 230, Visits: 692
geoff-635333 (6/25/2013)
I always forget it too - but only at the end of the session




<><
Livin' down on the cube farm. Left, left, then a right.
Post #1467153
Posted Tuesday, June 25, 2013 8:04 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 7:03 AM
Points: 814, Visits: 546
I wonder how many people use them?
Post #1467168
Posted Tuesday, June 25, 2013 8:07 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 230, Visits: 692
Use what?




<><
Livin' down on the cube farm. Left, left, then a right.
Post #1467172
Posted Tuesday, June 25, 2013 9:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 22, 2013 2:03 AM
Points: 12, Visits: 45
I have successfully used temporary Stored Procs for Years.
They are very powerful features.
Post #1467228
Posted Tuesday, June 25, 2013 9:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 16, 2013 11:37 AM
Points: 97, Visits: 309
How would you use them. I cannot think of a case where this would be useful?
Post #1467232
Posted Tuesday, June 25, 2013 9:53 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, September 29, 2013 1:24 AM
Points: 429, Visits: 1,721
Hmmm...I had no idea this was possible. The concept completely slipped by me! I learned something new today. Thanks!

As for usefulness...I saw the potential as soon as I read this article. Too many times I've had to create separate procedures or functions just for the purpose of simplifing my code that are only relevant to the proc they run in due to hard-coded values, etc. Temp procedures will encapsulate that code within the procedure itself without adding another variation to maintain. I will be able to use this right now on some procedures I'm working on.

 
Post #1467254
Posted Tuesday, June 25, 2013 9:58 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 230, Visits: 692
In Oracle you can create "local" procedures that are only available to the current process being executed. The local procedure keeps you from have to duplicate code sections that you need to repeatedly invoke. My understanding is that a temporary Stored procedure would serve the same purpose. IMHO, leave it to Microsoft to take something simple and obfuscate it.

<><
Livin' down on the cube farm. Left, left, then a right.
Post #1467257
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse