I get "Line 1: Incorrect syntax near ')'." when using SqlClient ExecuteScalar

Hi Marc,

I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using

ExecuteNonQuery method.

can you guide me about solving this issue?

Regards,

Anni

Anni wrote:

Hi Marc,

I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using

ExecuteNonQuery method.

can you guide me about solving this issue?

Regards,

Anni

Hi Anni,

There must be sth wrong in your procedure. Pls paste the whole procedure here and you'll get your answer.

|||Yes, this is just a sql syntax error. Usually it is best to get the sql and try to run it from query analyzer (or SQL Server Management Studio) until you get the syntax correct.