how to declare functions at server level

Is there any procedure or table called dbo.fn_strt date and dbo_fn_enddate where we can update the input parameters at server level?
parpaaAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
they must be on the database level... in sql 2005 sql server management studio:
programmatibility -> stored functions
0
 
Anthony PerkinsCommented:
No.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree.
usually, you would declare them in the master database...
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
parpaaAuthor Commented:
where exactly?? is that in table or a procedure??can it be database specific or only server specific??
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I think there is some room for misunderstanding ...

can you please clarify if you
* have those functions, and don't know if they do exist on all sql servers by default
* don't have those functions, and want to know how to get them
* want to have those functions available in your sql servers, in all databases available
* something else.
0
 
parpaaAuthor Commented:
This is the request i got...

update dbo.fn_startdate(@a, @b, @c) and dbo.fn_enddate(@a, @b, @d) to include parameters to provide begin and end dates for:
1. Parameter X
2.Parameter Y
3.Parameter Z

0
 
parpaaAuthor Commented:
As i am not sure about, so asking for help where to update it..
0
 
Anthony PerkinsCommented:
I am afraid I have no idea what it is you are asking.
0
 
parpaaAuthor Commented:
I have those functions in my server and i dont know where they are to update it.. hope i am clear this time..
0
 
parpaaAuthor Commented:
Thanks.. got it..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.