CirquedeSQLeil (4/21/2010)[hr
I still disagree. This is used as a catch-all to avoid teaching moments. I don't use the ; at the beginning of the cte, but rather as a terminator at the previous clause. Not all cte's require a ;, since many do not follow another batch or statement. If somebody doesn't terminate their statement properly, then teach them and catch the error via code review.
I would really, really love it if I could come to agreement with every developer in our team on the semicolon usage. Unfortunately, the usual response I get is something like "the semicolons are not required yet, so why bother using them". I totally disagree with this logic, but it is prevalent for now.
All I was trying to point out was that from the perspective of the person who actually wrote the recommendation it does make sense considering the facts that unfortunately, many people still don't use semicolons 🙁
Oleg