INSERT OUTPUT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » INSERT OUTPUT

63 posts, Page 2 of 7

««1 2 3 4 5 »»»

INSERT OUTPUT

Rate Topic

Display Mode

Topic Options

Author

Message

abhishekgupta109

Posted Thursday, February 02, 2012 2:27 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 7:17 AM
Points: 11, Visits: 25

good one.

Post #1245561

BenWard

Posted Thursday, February 02, 2012 2:28 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, June 06, 2013 2:10 AM
Points: 324, Visits: 532

Ah cool. As expected it worked fine on 2k5 when I set the data type to DATETIME

Looks like a really useful funtion. I shall be using it a lot I'm sure!

Ben

^ Thats me!

----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

Post #1245564

cengland0

Posted Thursday, February 02, 2012 3:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use this method to keep track of the changes performed by those users. Nice if you are asked to provide information such as who updated the record and what was changed.

Post #1245594

Gazareth

Posted Thursday, February 02, 2012 4:30 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 4:11 AM
Points: 1,474, Visits: 2,344

Cheers Steve, I was looking for the trap too!

I love this feature, actually currently writing lots of them for a data migration project.

Post #1245625

Stuart Davies

Posted Thursday, February 02, 2012 4:43 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 2,501, Visits: 2,202

Simple question - thanks.
No trap - thanks.
Points today - thanks

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Post #1245637

Michael Riemer

Posted Thursday, February 02, 2012 5:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 1,261, Visits: 357

Nice simple basis question - Thanks! I did have to double check looking for the trick though!!!

Post #1245660

Thomas Abraham

Posted Thursday, February 02, 2012 5:25 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:11 AM
Points: 1,168, Visits: 1,470

Stuart Davies (2/2/2012)

Simple question - thanks.
No trap - thanks.
Points today - thanks

I agree, and am also concise and grateful.

Please don't go. The drones need you. They look up to you.

Post #1245671

SQLRNNR

Posted Thursday, February 02, 2012 6:06 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443

Thanks Steve

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1245713

Victor Kirkpatrick

Posted Thursday, February 02, 2012 6:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 1,385, Visits: 295

Good question about a very useful feature that a lot of people do not appear to know about. You can also use the OUTPUT clause with the MERGE command too. It's especially useful when you need to know a range of values that were inserted so that you have the newly generated keys in order to also insert data into detail tables below the insert.

Post #1245730

call.copse

Posted Thursday, February 02, 2012 6:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:33 AM
Points: 1,113, Visits: 717

Hand up, I did not know about it. I can definitely see uses for this OUTPUT thingy though - cheers.

Post #1245736

« Prev Topic | Next Topic »

63 posts, Page 2 of 7

««1 2 3 4 5 »»»

Permissions