Insert With Output Cluase, Sql Server

Language: Layout:

-- Insert With Output
-- Insert With Output
-- Insert With Output
-- Insert With Output
-- Insert With Output
-- Insert With Output

create table MyOrders(
orderid INT NOT NULL identity(1,1) PRIMARY KEY,
custid INT NOT NULL,
empid INT NOT NULL,
orderdate DATE NOT NULL
)

create table SomeTable(
orderid INT NOT NULL identity(1,1) PRIMARY KEY,
custid INT NOT NULL,
empid INT NOT NULL,
orderdate DATE NOT NULL
)

DECLARE @Orders AS TABLE(
orderid INT NOT NULL PRIMARY KEY,
custid INT NOT NULL,
empid INT NOT NULL,
orderdate DATE NOT NULL,
shipcountry varchar(100)
);

INSERT INTO @Orders(orderid, custid, empid, orderdate,shipcountry) VALUES
    (2, 1, 3, '20120612','Norway'),
    (3, 2, 2, '20120612','Norway'),
    (4, 3, 5, '20120612','India');

--Get Inserted Data using output cluase
    insert into MyOrders (custid,empid,orderdate)
    output inserted.orderid,inserted.custid,inserted.orderdate
    select custid,empid,orderdate from @Orders
    
    
    -- insert data in other table using output and into cluase
    INSERT INTO MyOrders(custid, empid, orderdate)
    OUTPUT
    inserted.custid, inserted.empid, inserted.orderdate
    INTO SomeTable(custid, empid, orderdate)
    SELECT custid, empid, orderdate
    FROM @Orders
    WHERE shipcountry = N'Norway';

select * from SomeTable

View schema
Execution time: 0.03 sec, rows selected: 2, rows affected: 8, absolute service time: 0.27 sec