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
6 Comments
What was the first blogpost you wrote?
http://devpinoy.org/blogs/bonskijr/archive/2006/02/15/Image-In-DetailsView.aspx
When did you write it?
Feb 15 2006
What was it about?
How to display a blob(image) from the database to a DetailsView ASP.NET server control, in response to a local forum question (http://msforums.ph/forums/p/31880/108971.aspx#108971)
It’s my (relatively) most viewed post (8K)
Since then I’ve gravitated more to SQL server related posts, but has not blogged since 2009 ๐
I remember it very clearly. Mark Smith caused my LTD blogging career thanks to a forum thread and schema questions.
http://blogs.lessthandot.com/index.php/ITProfessionals/ProfessionalDevelopment/why-i-started-and-continue
Now blogging started over a decade ago but I consider coming into form and providing some truly valued content to Mark, LTD and the others that help me review/edit what I write.
Just published my first ones, my first real one:
http://www.spreadsheetbudget.com/2012/01/04/import-data-from-excel-to-vba/
If we don’t consider FAQs in UniversalThread.com and an article (in Russian) in foxclub.ru website around 2000, my first blog post was here in July 2009
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-search-for-all-words-inclusive-wi
Here’s my entry:
http://bertrandaaron.wordpress.com/2012/01/09/my-first-blog-posts/
And mine is up:
http://blogs.lessthandot.com/index.php/ITProfessionals/ProfessionalDevelopment/meme-monday-my-first-blog
A heads up next would be nice Denis ๐