导表

delete from User_Withdraw_Detail

delete from User_Withdraw_Order



delete from User_Withdraw_Review


select * from User_Withdraw_Review

insert into User_Withdraw_Review(ID,UWID,UWDID,[Date],WID,[Status],Invoice,Note)
select ID,UW_ID,0 ,[Date],W_ID,Status,Invoice,Note from WithdrawReview

set identity_insert User_Withdraw_Order ON
insert into User_Withdraw_Order(ID,UID,CreateDate,Amount,[Status],Tax,RealityAmount)
select ID,UID,[Date],Amount,[Status],Tax,RealityAmount from User_Withdraw
set identity_insert User_Withdraw_Order OFF
原文地址:https://www.cnblogs.com/l25321937/p/3189650.html