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

最新推荐文章于 2025-08-07 00:36:46 发布

最新推荐文章于 2025-08-07 00:36:46 发布 · 440 阅读

本文介绍了在 SQL Server 中正确调用 scalar user-defined functions 的方法，即在函数名前加上 schema 名称以确保调用成功。此外，还列举了一些内置函数的使用示例。

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

<wbr></wbr>