代码改变世界

导表

2013-07-14 17:00  l25321937  阅读(232)  评论(0)  编辑  收藏  举报 
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