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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

David Hager said:

Congratulations!

July 20, 2011 8:39 PM
 

Adam Machanic 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

Leave a Comment

(required) 
(required) 
Submit

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.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement