Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting and selecting at the same time
Message
From
23/09/2013 10:13:46
Kevin Goff
Pennsylvania, United States
 
 
To
23/09/2013 10:10:09
Christian Isberner
Hannover, Germany
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Inserting and selecting at the same time
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01583879
Message ID:
01583880
Views:
47
Starting in SQL 2005, they added an OUTPUT statement that you can add to the end of an INSERT statement.

it allows you immediately "get at" the values you inserted, even identity columns.

I'll type out an example in a second.
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Previous
Reply
Map
View

Click here to load this message in the networking platform