Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Insert With Output Cluase
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
-- 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
edit mode
|
history
|
discussion
orderid
custid
orderdate
1
1
1
6/12/2012 12:00:00 AM
2
2
2
6/12/2012 12:00:00 AM
3
3
3
6/12/2012 12:00:00 AM
orderid
custid
empid
orderdate
1
1
1
3
6/12/2012 12:00:00 AM
2
2
2
2
6/12/2012 12:00:00 AM
stackse - search stackoverflow differently