数据库表备份语句

SELECT *
INTO tHWStockOut_20181015 
FROM tHWStockOut

SELECT *
INTO tHWStockOutSub_20181015 
FROM tHWStockOutSub

BEGIN TRANSACTION
delete from tHWStockOut
where cStorageCode = '2018000738'

delete from tHWStockOutSub
where cStorageCode='2018000738'

COMMIT TRANSACTION

select * into dbo.tHWCourier_2018_05_09_17_05 from tHWCourier

 

BEGIN TRANSACTION
--COMMIT TRANSACTION
--ROLLBACK TRANSACTION 
select * from tHWOrderInfo where cOrderID = '20190515001165' and iState = 3
select * from tHWDeliveryList where cOrderCode in (select cOrderCode from tHWOrderInfo where cOrderID = '20190515001165' and iState=3)
--update tHWOrderInfo set cScanCodeHuman='宇冯', dScanCode=GETDATE()  
--where cScanCodeHuman is null and iState = 3 and cOrderID='20190515001165'
--update tHWDeliveryList set iScanCode = 2 where cOrderCode in (select cOrderCode from tHWOrderInfo where cOrderID = '20190515001165' and iState=3)
select * from tHWDelivery 
where cBatchCode in (select cBatchCode from tHWDeliverySub where cDeliveryOrder in (select cDeliveryOrder from tHWDeliveryList 
where cOrderCode in(select cOrderCode from tHWOrderInfo where cOrderID = '20190515001165' and iState = 3)))

--update tHWDelivery set iState = 2 
--where iState=1 and cBatchCode in (
--    select cBatchCode 
--    from tHWDeliverySub 
--    where cDeliveryOrder in (
--        select cDeliveryOrder 
--        from tHWDeliveryList 
--        where cOrderCode in(
--            select cOrderCode 
--            from tHWOrderInfo 
--            where cOrderID = '20190515001165' and iState = 3
--        )
--    )
--)