Execute a UDF

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • love2livedislife
    New Member
    • Feb 2008
    • 2

    Execute a UDF

    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:)
Working...