How to execute a UDF in SQL Server without fully qualified name?
Requirement:
I have to create a UDF named say "ADDNUM" inside schema "test1".
While executing i have to give fully qualified name as follows:
select test1.ADDNUM();
But how to execute the same without appending test1 while executing??
Thanks in Advance:)
Requirement:
I have to create a UDF named say "ADDNUM" inside schema "test1".
While executing i have to give fully qualified name as follows:
select test1.ADDNUM();
But how to execute the same without appending test1 while executing??
Thanks in Advance:)