User Defined Functions
-
Okay so I have a production DB and a developement DB. Well I am using some UDF's in my stored procedures, and I am using the full object reference in my code...such as
Database.dbo.function(param)
But I need to move these into production, but I will need to change the line to reference the correct DB??? My question is...Is there a better way to call the functions that will not require the DB name...so I can easily move mods to my SP's from dev into production.
-
I'm confused. Have you tried this?
dbo.function(param)
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
>>I'm confused. Have you tried this?
>>dbo.function(param)
No I have not tried this...I will test it now.
Thank You...
-
Dude...that totally works...Thank You!!!!!!!!!!
-
Glad to help - thanks for the feedback. It's often the easy things which stump us...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply