Is there a way to call a function without prefixing it with the database and/or owner name?
Example... fn_myfunction under the Sample Database
Currently I call it as followed...
Update mytable Set myfield = Sample.dbo.fn_myfunction(123)
I'd like to call it like this...
Update mytable Set myfield = fn_myfunction(123)
Thanks for the help,
Stephen
Example... fn_myfunction under the Sample Database
Currently I call it as followed...
Update mytable Set myfield = Sample.dbo.fn_myfunction(123)
I'd like to call it like this...
Update mytable Set myfield = fn_myfunction(123)
Thanks for the help,
Stephen