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

Related Posts