ALTER PROCEDURE [dbo].[CreateStuff]
    @colA datetime,
    @colB varchar(50),
    @colC nvarchar(20)
AS
BEGIN
SET NOCOUNT ON;
    INSERT INTO Table1
        (
            colA,
            colB,
            colC
        )
    SELECT  @colA,
            @colB,
            @colC
END

BEGIN
SET NOCOUNT ON;

 /* Here declare a Table Variable */

DECLARE @Table_Var TABLE(itemID INT)



    INSERT INTO Table1(colA,colB,colC)
    OUTPUT inserted.itemID  INTO @Table_Var(itemID)
    SELECT  @colA,@colB,@colC


    /* Now do the insert into Table 2*/

    INSERT INTO TABLE2
    SELECT itemID FROM @Table_Var
END

ALTER PROCEDURE [dbo].[CreateStuff]
    @colA datetime,
    @colB varchar(50),
    @colC nvarchar(20),
    @Valueout int output
AS
BEGIN
SET NOCOUNT ON;
    INSERT INTO Table1
        (
            colA,
            colB,
            colC
        )
    SELECT  @colA,
            @colB,
            @colC
SET @Valueout = SCOPE_IDENTITY()
END

CREATE TRIGGER Trigger_Name
       ON  Table_Name
       AFTER INSERT,UPDATE
    AS
    BEGIN
       SET NOCOUNT ON;

       INSERT INTO Table1 ( colA, colB, colC )
       SELECT  colA, colB, colC FROM Inserted

    END