Koen Verbeeck (2/14/2012)

---

Great question, thanks Henrico.
I stumbled across this issue a few times too many, so a real easy one for me

danielfountain (2/14/2012)

---

But surely without running the code there would be no output :0)

kll 51891 (2/14/2012)

---

I would have expected it to fail due to no newline or semicolon.
But it were not so
Anywhere I can find specific rules about when to use and when not to use semicolon?
Except the reserved word ";with" of course.

Koen Verbeeck (2/14/2012)

---

The semicolon is not yet obligated, except when using the WITH clause. This probably will change in a future version.
If there's a statement before the WITH clause, it should be terminated with a semicolon. Pay attention, this is not the same as saying that it should be ";WITH". If everyone starts terminating statements with semicolon in old code to make the code portable to a newer edition of SQL Server, all ;WITH statements will fail.

use master
select top 10 * from sys.all_columns
select top 10 * from sys.all_objects
select top 10 * from sys.all_columns select top 10 * from sys.all_objects
select top 10 * from sys.all_columns ;; select top 10 * from sys.all_objects

Select *
From xx
Where something is right