Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Execution error: 'the function name is not a recognized built-in function name'

SQL Server scalar user defined functions must be called with 2 part names. You need to write as username before function.
So if your function name is "function1" and is defined in the dbo schema, then instead of
"select function1()" you should call it as "select dbo.function1()"
Functions will run like below:

select dbo.AVG(columns name) from (table_name) - Returns the average value
select dbo.COUNT(columns name) from (table_name) - Returns the number of rows
select dbo.FIRST(columns name) from (table_name) - Returns the first value
select dbo.LAST(columns name) from (table_name) - Returns the last value
select dbo.MAX(columns name) from (table_name) - Returns the largest value
select dbo.MIN(columns name) from (table_name) - Returns the smallest value
select dbo.SUM(columns name) from (table_name) - Returns the sum
Share this article   |    Print    |    Article read by 5703 times
Author:
Rohit kakria
I am software developer
Related Articles: No related article
Related Interview Questions: No related interview question