怎样实现这样的sql语句?

f1是日期类型,f2是数字类型,
要求完成下面的sql

delete from table where <请填写>

实现功能:

今天与f2的日期差值(天)如果大于f2的数值,就删除纪录。
---------------------------------------------------------------

strSQL="delete from table where DATEDIFF(day, " & f1 & ", getdate()) > " & f2
---------------------------------------------------------------

那就去掉那些引用的符号啊! ^_^

Published At
Categories with Web编程
Tagged with
comments powered by Disqus