I am sitting in Kalen Delaney;s session on Locking, Blocking, Versions: Concurrency for Maximum Performance and had a great idea for a SQL Server Teaser. <<<<<
Without running it, what will printed when the following two blocks of code are run?
Now run it.... Were you right?
What about the code below, what will happen if you run these two code blocks? Does it matter that the transactions are created in separate batches?