sqlserver 循环临时表插入数据到另一张表
2016 年 09 月 11 日 12:31:15windowsliusheng阅读数：2273
-- 声明变量
DECLARE
@SupCode as varchar(100),
@ProdCode as varchar(50),
@PackLayer as varchar(50),
@CodeStatus as varchar(50),
@ProductId as varchar(50),
@subTypeNo as varchar(50),
@PackageSpecID as varchar(50),
@UpdateTime as varchar(50),
@errorCount as int=0;
while exists(SELECT supcode FROM ##SupCode)
begin
-- 也可以使用 top 1
SET ROWCOUNT 1
SELECT
@SupCode=SupCode,@ProdCode=ProdCode,@PackLayer=PackLayer,@C
odeStatus=CodeStatus,
@ProductId=ProductId,@subTypeNo=subTypeNo,@PackageSpecID=Packa
geSpecID,@UpdateTime=UpdateTime FROM ##SupCode;
SET ROWCOUNT 0
begin transaction; --声明事物
INSERT INTO [Origin_System].[dbo].[Supcode]
([SupCode]
,[CheckPwd]
,[ProdCode]
,[PackLayer]
,[CodeStatus]
,[ParentCode]
,[PrintBatchNo]
,[TaskID]
,[ProductId]
,[subTypeNo]
,[PackageSpecID]
,[PackFlag]
,[EquipmentID]
,[ScanNo]
,[BoxNo]
,[UnitID]
,[UpdateTime])
评论0