June 2, 2014 at 9:40 am
Hello,
Can an INSERT statement also return all columns inserted as a result set? If so what clause of the INSERT statement does this?
Thanks,
June 2, 2014 at 9:47 am
Can you explain further? maybe with examples.
An insert will insert rows, not columns. You might have a valid request but I'm confused.
June 2, 2014 at 9:50 am
You can use the OUTPUT clause for that.
Here is a link with examples
http://technet.microsoft.com/en-us/library/dd776381(v=sql.105).aspx
Go down to the "Capturing the Results of the INSERT Statement" section.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply