Getting an odd error, SQL Server query using `WITH` clause

[Origin]: http://stackoverflow.com/questions/2746916/getting-an-odd-error-sql-server-query-using-with-clause

always use with statement like ;WITH then you’ll never get this error. The WITH command required a ; between it any any previous command, by always using ;WITH you’ll never have to remember to do this.

see WITH common_table_expression (Transact-SQL), from the section Guidelines for Creating and Using Common Table Expressions:

When a CTE is used in a statement that is part of a batch, the statement before it must be followed by a semicolon.

shareimprove this answer
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s