在 SQL 中调用动态函数名

2021-09-10 00:00:00 sql tsql sql-server sql-function

是否可以在 SQL 中调用具有动态名称的函数?

Is it possible to call a function with a dynamic name in SQL?

例如:

SELECT functionid, (SELECT results FROM dbo.Function_*functionid*) AS results
FROM List_of_Functions

这将为表 List_of_Functions 中的每一行调用不同的函数.

This would call a different function for every row in the table List_of_Functions.

还是我的想法都错了?

推荐答案

您将需要构建(输入或基于您的表动态构建)SQL 语句，如:

You will need to build (either type it in, or build it dynamically based on your table) a SQL statement like: 

SELECT
    functionid
        ,CASE  functionid
            WHEN 1 THEN dbo.Function_1()
            WHEN 2 THEN dbo.Function_2()
            WHEN 3 THEN dbo.Function_3()
         END AS results
    FROM List_of_Functions

与其构建所有这些函数，不如构建一个函数，然后传入一个函数可以用来区分处理的值，这不是更好吗?喜欢:

Instead of building all those functions, wouldn't it be better to build one function, and pass in a value that the function can use to differentiate the processing? like:

SELECT
    functionid
        ,dbo.Function(functionid) AS results
    FROM List_of_Functions_Parameters

相关文章