一个简单问题求教sql语句

[xianxian123xian]

select * from MemberOrder +'@Keywords'+order by id desc ，
'+' 附近有语法错误。
keyword传的是条件，where及后面的语句，

[zytp]

看似没问题。注意@keywords前后要留出空格 防止变成select * from memberorderwhere 1=1order by id desc

[广交天下好友]

select * from MemberOrder where 字段= @Keywords order by id desc ，

[bdmh]

如果Keywords是sql语句中的参数，就这样
"select * from MemberOrder @Keywords order by id desc"

如果Keywords是变量，就这样
"select * from MemberOrder "+Keywords+" order by id desc"

[EnForGrass]

请注意空格

[是时候重装系统了]

select * from MemberOrder +'@Keywords'+ order by id desc ，

[xianxian123xian]

谢谢各位，已解决这样写 exec(' select * from MemberOrder '+@Keywords+' order by id desc')