删除表a数据插入表b
2017-11-20 本文已影响0人
老练子丶2017
delete from t_user_right output deleted.user_idx,deleted.object_idx,deleted.ctime,GETDATE(),
deleted.type into t_user_right_his(user_idx,object_idx,ctime,del_dt,type) where type = 2 and
ctime < '2013-11-11 00:00:00'
