如何为SQL存储过程中的可选参数传递一组值？

CREATE PROCEDURE MyProcedure
    @Param1 INT = NULL,
    @Param2 VARCHAR(50) = 'Default'
AS
BEGIN
    -- 存储过程逻辑
END

CREATE PROCEDURE MyProcedure
    @ParamList TABLE (Value INT)
AS
BEGIN
    -- 使用 @ParamList 中的值
    SELECT * FROM SomeTable WHERE Id IN (SELECT Value FROM @ParamList)
END

DECLARE @ParamList TABLE (Value INT)
INSERT INTO @ParamList (Value) VALUES (1), (2), (3)

EXEC MyProcedure @ParamList = @ParamList

CREATE PROCEDURE MyProcedure
    @Param XML
AS
BEGIN
    -- 解析 @Param 中的值
    SELECT * FROM SomeTable WHERE Id IN (
        SELECT ParamValues.ID.value('.', 'INT') 
        FROM @Param.nodes('/Root/Item') AS ParamValues(ID)
    )
END

DECLARE @Param XML
SET @Param = '<Root><Item>1</Item><Item>2</Item><Item>3</Item></Root>'

EXEC MyProcedure @Param = @Param

CREATE PROCEDURE MyProcedure
    @Param VARCHAR(MAX)
AS
BEGIN
    DECLARE @SQL NVARCHAR(MAX)
    SET @SQL = 'SELECT * FROM SomeTable WHERE Id IN (' + @Param + ')'
    EXEC sp_executesql @SQL
END

EXEC MyProcedure @Param = '1,2,3'