CODEWITHSUNDEEP
sql-server-2008-r2
Deepak Kumar
Deepak Kumar

Reputation: 863

Parsing error in Microsoft SQL Server Management studio 2008 R2

Here is the CTE query which I am trying to execute:

Parsing error in in CTE query SQL server

The query works fine as you could see in the Live Demo but this IDE is giving me a tough time by giving me the parsing error around the "with" keyword used in the CTE query..

Upvotes: 1

Views: 644

Answers (1)

Deepak Kumar
Deepak Kumar

Reputation: 863

The issue was with the SQL server compact edition..

When I used to create a local db in the IDE with SQL server compact edition, it didn't support the CTE but when I connected to our actual database and then ran the CTE query, it worked.

Even its given in the below link that the compact version does not support CTE:

https://msdn.microsoft.com/en-us/library/bb896140(SQL.100).aspx

Upvotes: 1

Related Questions