Beginning a CTE

Question

Post reply

Beginning a CTE

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 1

Woops, I selected no before reading the third option. I want a do over 😛

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Plenty of comments thus far.

As written (even today and so long after the creation of this question), the answer should be NO. Pedantics about the words in the question. The use of always is an indicator of NO.

Furthermore, even if the previous statement is not terminated, a semi-colon is not actually required.

Case in point with this sample code:

USE AdventureWorks2014;

GO

SELECT TOP 10 *

FROM Person.Person -- no semi-colon terminator here

BEGIN --oh wait a batch separator here without a semi-colon still

WITH proofinpoint AS (

SELECT *

FROM Person.Person

)

SELECT TOP 10 *

FROM proofinpoint pp

ORDER BY BusinessEntityID DESC;

END

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

mister.magoo SSC-Forever Points: 47068 More actions · Answer 3

martin.whitton (6/3/2016)
Anyone who doesn't terminate SQL statements with a semicolon should note the following (from https://msdn.microsoft.com/en-us/library/ms177563%28v=sql.110%29.aspx ):
Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version of SQL Server, it will be required in a future version.
It's much easier to start doing this now than have to apply it to all your code at once when it becomes compulsory!

Just an update on this...unofficial, but worth noting:

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);