不是没有人会,是因为没有人:)
sql="select top 50 * from Article where instr('|29|42|43|44|45|46|47|48|49|50|51|52|53|54|55|56|','|" + Classid + "|')<>0 order by id desc"
sql="select top 50 * from Article where instr('|29|42|43|44|45|46|47|48|49|50|51|52|53|54|55|56|','|" + Classid + "|')<>0 order by id desc"
Classid IN (29,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56)
子句也可以吧?sql="SELECT top 50 * FROM Article WHERE " + Classid + " IN(29,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56) ORDER BY id DESC"
的方法不可以吗?
Classid会被认为是变量