Post reply

SELECT setter

  • February 18, 2010 at 12:26 am

    #1120693

    Oh, I know that. From the perspective of someone who started with SQL Server way back in 91 it's completely clear. But for the less experienced it can certainly appear strange and unexpected.

    Just because you're right doesn't mean everybody else is wrong.

  • March 30, 2010 at 8:49 am

    #1142293

    This difficult-to-recall behaviour is the main reason I prefer SET @x = (SELECT...) syntax.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply