I have the following error message
If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon
when i launch a query from my c# code. The same query works on sql server.
The query is
with a as (SELECT ROW_NUMBER() OVER (ORDER BY xxx) AS num , * from dbo.xxx) select top (200) * from a as selezione