MarkusB (11/3/2011)
I agree with Philip, non of the given answers is correct.The question explicitly says 2005 or higher, but the result on a 2005 server is different from a 2008 server.
I'm with these guys... I was staring at it and saying over and over assigning values at variable declaration was a 2008 feature that I love, and something I knew you couldn't do with 2005.
I took a random guess since they were all wrong with 2005