请问Sql的DELETE语句怎么写?
来源:百度知道 编辑:UC知道 时间:2024/06/12 05:30:34
请问,如何指定2个条件进行查询?
strSqlDelete = "DELETE FROM ”表名” WHERE (A=" + a + ")";
条件B=b怎么加进去呢?(a,b是方法的参数,A,B是列名),谢谢了...
strSqlDelete = "DELETE FROM ”表名” WHERE (A=" + a + ")";
条件B=b怎么加进去呢?(a,b是方法的参数,A,B是列名),谢谢了...
delete from 表名 where A = 'a' and B = 'b'
实在不会的话去SqlServer里面生成...
strSqlDelete = "DELETE FROM ”表名” WHERE (A=" + a + " AND B="+b+")"; AND 是我自己表示的, 你可以根据自己来改成其他的
delete from 表名 where A = 'a' and B = 'b'
delete from 表 where 条件
Delete 表名 from 表名 where A="a" and B="b"