for (int i = 0; i < 3; i++) { for (int j = 0; j < 3; j++) {string sql3 = "select id,state from [StockState] where id = '" + (100000 + 100 * i + j) + "' ";這上面是一個循環(huán),這么寫,查不出數(shù)據(jù),請問后面id怎么寫運算表達式啊
2 回答

慕田峪7331174
TA貢獻1828條經(jīng)驗 獲得超13個贊
select * from a where b in(‘1’ , ‘2’, ‘3’) and c <> '4'
select * from a
where b like '%1%'
and b like '%2%'
and b like '%3%'
and c not like '%4%'
添加回答
舉報
0/150
提交
取消