Insert With Output Cluase, Sql Server

Insert With Output Cluase

-- 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


run \| edit \| history \| help	0