dionisio_79
asked on
problem launching sql query from c#
Hi experts,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Show me your C# code you use to run the query.
ASKER
incorrect sintax near ','