Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stewart Campbell Operators RE: Operators

  • March 28, 2011 at 4:45 am

    #1304266

    I got it correct.

    I was surprised at first at the "SELECT @i+=1" syntax. I knew about the compount operators and have happily used "SET @i=1", but seeing never realised that it can equally well be used with SELECT.

    Thanks!

    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/