【文件属性】:
文件名称:sqlserver 循环临时表插入数据到另一张表
文件大小:24KB
文件格式:DOC
更新时间:2021-12-17 12:38:14
sql
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;