1、用友U8数据库付款订单数据插入

事项：AutoID不能更改，想移动底下两条表体数据ID是5411、5412到前一段时间数据的位置，如5033。然后5033之后的数据向下迁移两行。

解决方法：将5033~5412数据拷贝到临时表B ，在表B中的某个字段为空，类型int下拷贝源表A的AutoID。

select  *  INTO #A  from DispatchLists where AutoID >= 5033

SELECT * FROM DispatchLists WHERE AutoID >= 5033

SELECT * FROM #A 
--UPDATE #A SET AUTOID = 1 WHERE AutOID = 5033\

UPDATE #A SET cDefine34 = AutoID + 2 
UPDATE #A SET cDefine34 = 5033 WHERE AutoID = 5054
UPDATE #A SET cDefine34 = 5035 WHERE AutoID = 5055

UPDATE #A SET cDefine34 = 5037 WHERE AutoID = 5033
UPDATE #A SET cDefine34 = 5038 WHERE AutoID = 5035
UPDATE #A SET cDefine34 = 5039 WHERE AutoID = 5037
UPDATE #A SET cDefine34 = 5040 WHERE AutoID = 5038
UPDATE #A SET cDefine34 = 5041 WHERE AutoID = 5039
UPDATE #A SET cDefine34 = 5046 WHERE AutoID = 5040
UPDATE #A SET cDefine34 = 5047 WHERE AutoID = 5041
UPDATE #A SET cDefine34 = 5048 WHERE AutoID = 5046
UPDATE #A SET cDefine34 = 5049 WHERE AutoID = 5047
UPDATE #A SET cDefine34 = 5050 WHERE AutoID = 5048
UPDATE #A SET cDefine34 = 5051 WHERE AutoID = 5049
UPDATE #A SET cDefine34 = 5054 WHERE AutoID = 5050
UPDATE #A SET cDefine34 = 5055 WHERE AutoID = 5051

SELECT cDefine34 ,* FROM #A

UPDATE DispatchLists SET DLID = #A.DLID 
,cWhCode = #A.cWhCode ,
cInvCode = #A.cInvCode ,
iQuantity = #A.iQuantity ,
iUnitPrice = #A.iUnitPrice ,
iTaxUnitPrice = #A.iTaxUnitPrice ,
iMoney = #A.iMoney ,
iTax = #A.iTax ,
iSum = #A .iSum ,
iNatUnitPrice = #A.iNatUnitPrice ,
iNatMoney = #A.iNatMoney ,
iNatTax = #A.iNatTax ,
iNatSum = #A.iNatSum ,
cMemo = #A.cMemo ,
iSOsID = #A.iSOsID ,
iDLsID = #A.iDLsID ,
cInvName = #A.cInvName ,
iTaxRate = #A.iTaxRate ,
cSoCode = #A.cSoCode ,
cordercode = #A.cordercode ,
iorderrowno = #A.iorderrowno ,
irowno = #A.irowno 
FROM #A , DispatchLists
WHERE #A .cDefine34 = DispatchListS.AutoID 

UPDATE DispatchLists SET iDLsID = '100000' + CAST(AutoID AS VARCHAR(4)) WHERE AutoID >= 5033

UPDATE DispatchList SET cDLCode = 'D-000000001' + CAST( (RIGHT (cDLCode ,3) + 2 ) AS VARCHAR(3)) WHERE DLID >= 1000001714

UPDATE DispatchList SET cSysBarCode = '||SA01|' + cDLCode WHERE DLID >= 1000001711

UPDATE DispatchLists SET cbSysBarCode =