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

最新推荐文章于 2023-07-31 09:30:38 发布

衣舞晨风

最新推荐文章于 2023-07-31 09:30:38 发布

阅读量2.9k

点赞数

数据库专栏收录该内容

37 篇文章

订阅专栏

本文将详细解释如何在 SQL Server 中正确调用 scalar 用户定义函数 (UDF)，包括使用完整的命名空间以及展示常用函数如 AVG、COUNT、FIRST、LAST、MAX、MIN 和 SUM 的应用示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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