Question

删除一个指定日期的所有的数据的SQL语句怎么写！

删除一个指定日期的所有的数据的SQL语句怎么写！
假如删除2012-10-25到2012-10-31. Iq的值等于2001的记录（日期字段名为：Edate)

Answer 1

可以如下

delete from table where edate between '2012-10-25' and '2012-10-31' and iq = 2001
或
delete from table where edate >= '2012-10-25' and edate <= '2012-10-31' and iq = 2001

Answer 2

delete from 表名 where convert(varchar(10),edate,120) between '2012-10-25' and '2012-10-31' and iq = 2001

Answer 3

delete from table where Edate between '2012-10-25' and '2012-10-31' and iq = 2001