N
Nicolas Auvillain
Guest
I'm using the The SQL Server Wire Protocol Driver and if I run the following query: WITH test AS ( SELECT * FROM HumanResources.Department ) SELECT * FROM test; I get: HY000[319][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. if I run the same in SQL Server management studio, it works fine; but if I use the SQL Server Wire Protocol Driver, I get that error. That looks like a defect to me - the only non-default option I've selected is 'enable quoted identifiers'.
Continue reading...
Continue reading...