mardi 31 mars 2015

Use double quote in sql querys c#

I'm developing an application that executes queries in a Sqlserver database. One of these queries needs double quotes.



select ....soapenv="http://ift.tt/sVJIaE"...from...where...


I put the query in a string type variable. I use inverted bar to scape to scape the double quote and define them in the string. But when I execute my app, I get a error when my app execute this query.


This is the error message:



Incorrect syntax near the keyword 'declare'.

'soapenv' is not a recognized CURSOR option.


How could define my query?


Thanks in advance! Regards


Aucun commentaire:

Enregistrer un commentaire