34,576
社区成员
发帖
与我相关
我的任务
分享
select dateadd(mm,-1,getdate())就OK了
select *
from orgdb.dbo.tb
where timefield<dateadd(month, -1,
dateadd(day,datediff(day,0,getdate())
)
select dateadd(m,-1,getdate())
select dateadd(m,-1,getdate())
select *
into newdb.dbo.tb
from orgdb.dbo.tb
where timefield<dateadd(month, -1,
dateadd(day,datediff(day,0,getdate()) -- 当日零时
)
迁移数据