如何从SQL Server中的参数中动态计算表值并找到最小和最大目标

CREATE PROCEDURE FindMinMaxTarget
    @tableName NVARCHAR(50),
    @columnName NVARCHAR(50),
    @minTarget INT OUTPUT,
    @maxTarget INT OUTPUT
AS
BEGIN
    DECLARE @sql NVARCHAR(MAX)
    
    SET @sql = N'SELECT @minTarget = MIN(' + QUOTENAME(@columnName) + '), @maxTarget = MAX(' + QUOTENAME(@columnName) + ')
                FROM ' + QUOTENAME(@tableName)
    
    EXEC sp_executesql @sql, N'@minTarget INT OUTPUT, @maxTarget INT OUTPUT', @minTarget = @minTarget OUTPUT, @maxTarget = @maxTarget OUTPUT
END

DECLARE @min INT, @max INT

EXEC FindMinMaxTarget 'YourTableName', 'YourColumnName', @min OUTPUT, @max OUTPUT

SELECT @min AS MinTarget, @max AS MaxTarget