Question

请问Sql的DELETE语句怎么写？

请问，如何指定2个条件进行查询？
strSqlDelete = "DELETE FROM ”表名” WHERE (A=" + a + ")";
条件B=b怎么加进去呢？（a,b是方法的参数，A，B是列名），谢谢了．．．

Answer 1

delete语句怎么写

Answer 2

strSqlDelete = "DELETE FROM ”表名” WHERE (A=" + a + " AND B="+b+")"; AND 是我自己表示的, 你可以根据自己来改成其他的

Answer 3

delete from 表名 where A = 'a' and B = 'b'
实在不会的话去SqlServer里面生成...

Answer 4

Delete 表名 from 表名 where A="a" and B="b"

Answer 5

delete from 表名 where A = 'a' and B = 'b'