使用sql循环将多个表单行提交到表中

CREATE PROCEDURE InsertFormData
    @FormData TABLE (
        Column1 INT,
        Column2 VARCHAR(50),
        Column3 DATE
    )
AS
BEGIN
    DECLARE @RowCount INT = (SELECT COUNT(*) FROM @FormData)
    DECLARE @Counter INT = 1

    WHILE @Counter <= @RowCount
    BEGIN
        DECLARE @Value1 INT
        DECLARE @Value2 VARCHAR(50)
        DECLARE @Value3 DATE

        SELECT @Value1 = Column1, @Value2 = Column2, @Value3 = Column3
        FROM @FormData
        WHERE RowNumber = @Counter

        INSERT INTO FormData (Column1, Column2, Column3)
        VALUES (@Value1, @Value2, @Value3)

        SET @Counter = @Counter + 1
    END

    COMMIT
END