冯 海

一个程序新人菜鸟的日记,希望大家多多关照。QQ:32316131

SQL删除日期时间大于多久的数据datetime

select * from dbo.Ant_News
DELETE FROM dbo.Ant_News WHERE  NewsDate > '2017-1-3'

select * from dbo.Ant_News where NewsDate > '2017-1-11'

  

 

DELETE FROM dbo.Ant_JobWord WHERE  WordDate > '2018-10-8'

  

posted @ 2018-10-08 21:36  秋天来了哟  阅读(1904)  评论(0编辑  收藏  举报
认识就是缘份,愿天下人都快乐!
QQ: 32316131
Email: 32316131@qq.com