begin transaction
insert into t2 select * from t1 where datadiff(day, time, getdate()) > 30
if @@error <> 0
begin
rollback
return
end
delete t1 where datadiff(day, time, getdate()) > 30
if @@error <> 0
begin
rollback
return
end
commit
go
insert into t2 select * from t1 where datadiff(day, time, getdate()) > 30
if @@error <> 0
begin
rollback
return
end
delete t1 where datadiff(day, time, getdate()) > 30
if @@error <> 0
begin
rollback
return
end
commit
go
insert t2 select * from t1 where datediff(day,time,getdate())>30
delete t1 where datediff(day,time,getdate())>30
commit tran
as
insert into t2
select *
from t1
where DATEDIFF(day,t1, getdate()) >30