paul.james 64212 (3/28/2011)
OK, can somebody suggest why this returns "Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '='." on my 9.0.4207 SQL server?declare @i tinyint
SELECT @i = 0
while @i < 255
SELECT @i+=1
SELECT @i
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '='.
because 9.0 is a sql server 2005 edition and += is not supported in this version