一个简单问题求教sql语句
select * from MemberOrder +'@Keywords'+order by id desc ，
'+' 附近有语法错误。
keyword传的是条件，where及后面的语句，
[解决办法]
看似没问题。注意@keywords前后要留出空格 防止变成select * from memberorderwhere 1=1order by id desc
[解决办法]
如果Keywords是sql语句中的参数，就这样
"select * from MemberOrder @Keywords order by id desc"
如果Keywords是变量，就这样
"select * from MemberOrder "+Keywords+" order by id desc"
[解决办法]
请注意空格
[解决办法]
select * from MemberOrder +'@Keywords'+ order by id desc ，
