上传者: zhang_xintian
|
上传时间: 2019-12-21 22:19:21
|
文件大小: 24KB
|
文件类型: doc
sqlserver 循环临时表插入数据到另一张表
-- 声明变量
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;