THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Alberto Ferrari

OT: New transaction in the World Database

Wow! Today I hit F5 on this interesting transaction:

BEGIN TRANSACTION
    INSERT INTO World.Babies (Name, Surname, DateOfBirth, Gender)
    VALUES ('Arianna', 'Ferrari', '20110720', 'Female');

    UPDATE World.Parents SET STATUS = 'Happy'
    WHERE NAME = 'Alberto' AND Surname = 'Ferrari';
COMMIT

Thanks Caterina, I’m now the proud father of two babies, thanks to you!

And… yes, I am going to lose some sleep, this time without thinkink at Denali. Sorriso

Published Thursday, July 21, 2011 12:17 AM by AlbertoFerrari

Comments

 

David Hager said:

Congratulations!

July 20, 2011 8:39 PM
 

cinahcaM madA said:

Great news, congrats!!!

July 20, 2011 10:34 PM
 

Chris Webb said:

Congratulations!

July 21, 2011 3:37 AM
 

Bob Phillips said:

Congratulations Alberto. Isn't Signora Ferrari also happy? :-)

July 21, 2011 6:51 AM
 

AlbertoFerrari said:

@Bob,

I guess her status gets updated by some trigger... I just wonder whether it is the baby's birth or my status update... :)

July 21, 2011 9:47 AM
 

Francesco Quaratino said:

Auguroni Alberto!

July 21, 2011 12:46 PM
 

Marco Russo said:

You are legacy Alberto, I would have expected an MDX writeback statement instead than an old SQL one... :)

Congratulations!

July 21, 2011 1:08 PM
 

Jerry Hung said:

Congrats!! Transaction committed with no rollback :)

July 21, 2011 3:53 PM
 

Javier Guillen said:

Congratulations!!!  That is great news!!!!  I will be hitting F5 in the next few days too :)

July 21, 2011 9:32 PM
New Comments to this post are disabled

About AlbertoFerrari

Alberto Ferrari is a Business Intelligence consultant. He his interests lie in two main areas: BI development lifecycle methodologies and performance tuning of ETL and SQL code. His main activities are with SSIS and SSAS for the banking, manufacturing and statistical sectors. He is also a speaker in international conferences like European PASS Conference and PASS Summit.
Privacy Statement