Link to home
Start Free TrialLog in
Avatar of parpaa
parpaa

asked on

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?
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

No.
I agree.
usually, you would declare them in the master database...
Avatar of parpaa
parpaa

ASKER

where exactly?? is that in table or a procedure??can it be database specific or only server specific??
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.
Avatar of parpaa

ASKER

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

Avatar of parpaa

ASKER

As i am not sure about, so asking for help where to update it..
I am afraid I have no idea what it is you are asking.
Avatar of parpaa

ASKER

I have those functions in my server and i dont know where they are to update it.. hope i am clear this time..
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of parpaa

ASKER

Thanks.. got it..