Single quotation marks are required in SQL statements.

Single quotation marks are required in SQL statements.

There are two single quotes in the SQL statement conditions, but they are enclosed by single quotes,

For example, select * from control where column = ''if the condition in column is exec usp_Data '{0 }'

This is not easy to handle, so the syntax error will be reported when the SQL statement is used.

The solution is to use two single quotation marks in the column condition to represent a single quotation mark...

This solves the problem.

As follows:

Select * from control where column = 'exec usp_Data ''{0 }'''