• UMG Developer (7/6/2010)


    Nice question, thanks!

    I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome. 😉

    I doubt it. Most people consider that cheating, and try to work the answer out for themselves.

    And I think that it is quite well-known that table variables (like scalar variables) are not affected by rollbacks.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/