问我可以使用一个存储过程将值插入两个表中吗？

EN

CREATE PROCEDURE [dbo].[InserIntoTwoTables]
    @arg1 INT, 
    @arg2 INT,
    @arg3 INT, 
    @arg4 INT
AS
BEGIN


    INSERT INTO Table1 (col1 ,col2)
    VALUES (@arg1 , @arg2) 

    INSERT INTO Table2 (col3 ,col4)
    VALUES (@arg3 , @arg4) 



END
GO

CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName> 
    @Param1 INT, 
    @Param2 INT
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO TAB1
        (COL1)
    VALUES
        (@Param1)

    INSERT INTO TAB2
        (COL1)
    VALUES
        (@Param2)
END
GO

create or replace procedure insert_data()
as
begin
   insert into table1 values("a","b",100);
   insert into table2 values("a1","b1",1001);
end