quote:

---

Originally posted by Sitka

FROM BOL 2005

[;]
Optional Transact-SQL statement terminator. Do not type the brackets.


"it's definitely useless and maybe harmful".

---

SELECT 'thanks'

WITH
JOHN(prfid,prfdate) AS
(
SELECT prfid, prfdate FROM prfs
),
JILL(prfid,department) AS
(
SELECT prfid, department FROM prfs
)

SELECT A.prfdate, B.department FROM JOHN A
INNER JOIN JILL B
ON A.prfid = B.prfid

SELECT 'thanks';

WITH
JOHN(prfid,prfdate) AS
(
SELECT prfid, prfdate FROM prfs
),
JILL(prfid,department) AS
(
SELECT prfid, department FROM prfs
)

SELECT A.prfdate, B.department FROM JOHN A
INNER JOIN JILL B
ON A.prfid = B.prfid

quote:

---

You should get in the habit now of terminating all applicable statements
with semi-colons. This is becoming required as existing keywords are
re-purposed for new functionality, for example a semi-colon must append the
statement preceding any CTE definition (which starts with WITH) so that the
parser knows that WITH does not belong to the previous statement.

---