Question

sql语句where条件有运算公式怎么写

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) + "' ";这上面是一个循环，这么写，查不出数据，请问后面id怎么写运算表达式啊啊

Answer 1

string sql3 = "select id,state from [StockState] where id = '" + (100000 + 100 * i + j) + "' ";
改为
string sql3 = "select id,state from [StockState] where id=" + (100000 + 100 * i + j);
问题不在于公式，而在于id是个数值型字段，它的值不能用单引号括起来