1

Possible Duplicate:
Is there a way to use a function on a Microsoft SQL Server Query without using “dbo.” before the function?

i have a problem with my user-defined function in SQL Server, when i try to executes it without dbo it shows error

'GetApplicationNumber' is not a recognized built-in function name.

  SET @ApplicationNumber=dbo.GetApplicationNumber(SCOPE_IDENTITY())  --WORKING FINE

  SET @ApplicationNumber=GetApplicationNumber(SCOPE_IDENTITY()) --SHOWING ERRORS
Community
  • 1
  • 1
ajaykalyanynr
  • 35
  • 1
  • 8

1 Answers1

0

UDF always need the schema name when they are referenced,
and they makes statements readable and gives a slight increase in performance too.

Buzz
  • 6,030
  • 4
  • 33
  • 47