sqlserver 循環(huán)臨時(shí)表插入數(shù)據(jù)到另一張表

大小: 24KB

文件類(lèi)型: .doc

金幣: 1

下載: 0 次

發(fā)布日期: 2021-05-19
語(yǔ)言: 數(shù)據(jù)庫(kù)
標(biāo)簽: sql??

高速下載

資源簡(jiǎn)介

sqlserver 循環(huán)臨時(shí)表插入數(shù)據(jù)到另一張表 -- 聲明變量 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;