What was the first blogpost you wrote? When did you write it and what was it about.

Here is mine, it is from September 15, 2005, it was about something that trips people up

@@IDENTITY returns wrong identity field

When using @@IDENTITY I get the wrong results

I have seen this problem posted many times on newsgroups and It actually happened to a co-worker not too long ago

This ‘problem’ can occur when you do an insert into Table A and there is at trigger defined that fires when the insert happens and this trigger does an insert into table B.

What @@IDENTITY returns is actually the identity from Table B

In order to get the identity back from table A you should use SCOPE_IDENTITY() instead

Here is the link to the post: @@IDENTITY returns wrong identity field

Since the first post I have blogged almost 1100 times, 678 times on the SQL Server Code,Tips And Tricks, Perfomance Tuning blog and over 400 times here on lessthandot

Let’s hear your story, I am tagging the following people:

Ted Krueger @onpnt

Christiaan Baes @chrissie1

Aaron Bertrand @AaronBertrand

Denny Cherry @mrdenny

Buck Woody @buckwoody

Thomas LaRock @sqlrockstar

Kevin Kline @kekline

Eli Weinstock-Herman @tarwn

Mladen Prajdić @MladenPrajdic

Karen Lopez @datachick

Romeliz Valenciano @bonskijr

To all the others, leave me a comment that says what the post is about, has the date and also a link to the post