T-sql基于参数动态更改另一个函数中的函数名

CREATE FUNCTION dbo.GetDynamicFunctionName (@functionName NVARCHAR(50))
RETURNS NVARCHAR(MAX)
AS
BEGIN
    DECLARE @sql NVARCHAR(MAX)
    SET @sql = N'SELECT ' + @functionName + N'()'
    RETURN @sql
END
GO

CREATE FUNCTION dbo.Function1()
RETURNS NVARCHAR(MAX)
AS
BEGIN
    RETURN N'This is Function 1'
END
GO

CREATE FUNCTION dbo.Function2()
RETURNS NVARCHAR(MAX)
AS
BEGIN
    RETURN N'This is Function 2'
END
GO

DECLARE @dynamicFunctionName NVARCHAR(50)
SET @dynamicFunctionName = N'Function1'

DECLARE @dynamicSQL NVARCHAR(MAX)
SET @dynamicSQL = dbo.GetDynamicFunctionName(@dynamicFunctionName)

EXEC sp_executesql @dynamicSQL