sql 删除某个日期字段小于今天的所有数据

delete FROM I_PRO_STVALUE WHERE Datediff(day,CreateDate,GETDATE())>0

原文地址:https://www.cnblogs.com/fanshaomin/p/7418467.html