SQL Server SP - "IN"数组列表的Pass参数？

CREATE TYPE dbo.StudentIDList AS TABLE (
    ID INT PRIMARY KEY
)

CREATE PROCEDURE dbo.GetStudentsByID
    @IDs dbo.StudentIDList READONLY
AS
BEGIN
    SELECT * FROM Students
    WHERE ID IN (SELECT ID FROM @IDs)
END

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    // 创建命令和参数
    SqlCommand command = new SqlCommand("dbo.GetStudentsByID", connection);
    command.CommandType = CommandType.StoredProcedure;

    // 创建TVP参数
    DataTable studentIDs = new DataTable();
    studentIDs.Columns.Add("ID", typeof(int));
    studentIDs.Rows.Add(1);
    studentIDs.Rows.Add(2);
    studentIDs.Rows.Add(3);
    studentIDs.Rows.Add(4);
    studentIDs.Rows.Add(5);

    SqlParameter parameter = command.Parameters.AddWithValue("@IDs", studentIDs);
    parameter.SqlDbType = SqlDbType.Structured;
    parameter.TypeName = "dbo.StudentIDList";

    // 执行查询并获取结果
    using (SqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // 处理查询结果
        }
    }
}