select count(*) from Customer_Info where Customer_Number =" + kh + "and BR_Number_ID=" +sf + "and Reg_Tel_1="+ tel

其中kn,sf,tel是三个变量，kn是int类型，其它的都是stirng类型的，我在C#里执行的时候，它总是说有Reg_Tel_1附近有语法错误，我不知道怎么改，麻烦一下了。

select count(*) from Customer_Info where Customer_Number =" + kn + "and BR_Number_ID='" +sf + "' and Reg_Tel_1='"+ tel "'"
改成这样

谢谢

挺佩服斑竹的,每个问题都回答了~~

select count(*) from Customer_Info where Customer_Number =" + kn + "and BR_Number_ID='" +sf + "' and Reg_Tel_1='"+ tel "'"

and 前面还有个空格不要忘记了

SQL 语句最好用大写，标准哈。。

顶。。。
好久没来逛了。多来看看就可以学到不少东西呀！

晕!
就是叼!偶F!