Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting and selecting at the same time
Message
De
23/09/2013 10:13:46
Kevin Goff
Pennsylvanie, États-Unis
 
 
À
23/09/2013 10:10:09
Christian Isberner
Hannover, Allemagne
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Re: Inserting and selecting at the same time
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01583879
Message ID:
01583880
Vues:
46
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform