删除一个月前,三个月前, 6个月前,一年前的数据代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】删除一个月前,三个月前, 6个月前,一年前的数据

作者:Dezai.CN / 发布于2011/8/9/ 829

<div><span style="color: rgb(0,0,255)">DELETE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> 表名WHERE </span><span style="color: rgb(255,0,255)">datediff</span><span style="color: rgb(0,0,0)">(MM, AddTime,</span><span style="color: rgb(255,0,255)">GETDATE</span><span style="color: rgb(0,0,0)">()) </span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">DELETE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> 表名WHERE </span><span style="color: rgb(255,0,255)">datediff</span><span style="color: rgb(0,0,0)">(MM, AddTime,</span><span style="color: rgb(255,0,255)">GETDATE</span><span style="color: rgb(0,0,0)">()) </span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">DELETE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> 表名WHERE </span><span style="color: rgb(255,0,255)">datediff</span><span style="color: rgb(0,0,0)">(MM, AddTime,</span><span style="color: rgb(255,0,255)">GETDATE</span><span style="color: rgb(0,0,0)">()) </span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">DELETE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> 表名WHERE </span><span style="color: rgb(255,0,255)">datediff</span><span style="color: rgb(0,0,0)">(YY, AddTime,</span><span style="color: rgb(255,0,255)">GETDATE</span><span style="color: rgb(0,0,0)">()) </span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">

</span></div>

试试其它关键字

　删除数据　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)