如何在SQL过程中使用多个表类型参数来过滤数据？

CREATE TYPE CustomerTableType AS TABLE 
(
    CustomerID INT
);

CREATE PROCEDURE FilterOrdersByCustomers
    @CustomerList CustomerTableType READONLY
AS
BEGIN
    SELECT o.OrderID, o.OrderDate, c.CustomerName
    FROM Orders o
    INNER JOIN Customers c ON o.CustomerID = c.CustomerID
    WHERE c.CustomerID IN (SELECT CustomerID FROM @CustomerList);
END;

DECLARE @MyCustomers AS CustomerTableType;

INSERT INTO @MyCustomers (CustomerID) VALUES (1), (3), (5);

EXEC FilterOrdersByCustomers @CustomerList = @MyCustomers;

CREATE PROCEDURE FilterOrdersByCustomers
    @CustomerList CustomerTableType READONLY
AS
BEGIN
    -- 确保参数正确使用
    SELECT o.OrderID, o.OrderDate, c.CustomerName
    FROM Orders o
    INNER JOIN Customers c ON o.CustomerID = c.CustomerID
    WHERE EXISTS (SELECT 1 FROM @CustomerList WHERE CustomerID = c.CustomerID);
END;