SanDroid (3/28/2011)

---

I think setting variables with a SELECT statement like "SELECT @var1 = 1, @var2 =2" has always worked in SQL server.
I have a pre SQL 92 SQL command refference with examples and it is listed there.
It was also supported on MS SQL Server 7.

Christian Buettner-167247 (3/28/2011)

---

Why should the batch be terminated? I don't see any issues here.

Tom.Thomson (3/29/2011)

---

If ARITHABORT is ON and ANSI WARNINGS off, arithmetic overlow causes the batch to be aborted. See the second sentence of the remarks section of this BoL page.
SELECT @i+=1 will cause arithmetic overflow on the last iteration, attempting to set a tinyint to 256.

while @i < 255

UMG Developer (3/29/2011)

---

Why would it do that, the WHILE clause:

while @i < 255

shouldn't run the SELECT statement to increment @i when @i is 255. So the last iteration is with @i=254 getting incremented to 255.