±í±äÁ¿£¬¶¯Ì¬sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sql2005 ÉùÃ÷±í±äÁ¿
 declare @t_tablebarcode table(id int) ,barcode varchar(50) 
,PackLayer int,SubTypeID int,PkgRatioID int
,ResCodeID int,ImportID int 
,DeActiveID int ,ActiveID int)
¶¯Ì¬sql
set @t_SQL='insert into '+@tarGet+'(Barcode,rescodeid,importid,printid,activeid)
select barcode,rescodeid,importid,null,@p_cActiveID from 
tbarcodeimport where BARCODE in(select barcode from '+@t_tablebarcode+')'
exec @t_SQL
±àÒë³ö´í
ÏûÏ¢ 137£¬¼¶±ð 15£¬×´Ì¬ 2£¬¹ý³Ì ExportSubBarcode£¬µÚ 26 ÐÐ
±ØÐëÉùÃ÷±êÁ¿±äÁ¿ "@t_tablebarcode"¡£

---

ÓÃ實±í°É

---

set @t_SQL ='insert into '+@t_tablebarcode+' select top '+ @p_iCurCodeNum 
+'from tbarcodeimport where rescodeid='+@p_iLevelID+'order by id'

---

¸Õ¸Õд´íÁË£¬2Â¥µÄÊÇÄǸö¶¯Ì¬µÄsql

---

µÃÓÃÁÙʱ±í

create table #t_tablebarcode (id int) 


set @t_SQL='insert into '+@tarGet+'(Barcode,rescodeid,importid,printid,activeid)
select barcode,rescodeid,importid,null,@p_cActiveID from  
tbarcodeimport where BARCODE in(select barcode from #t_tablebarcode)'

---

ÏÖÔÚ²»ÏëÓÃÈ«¾ÖÁÙʱ±íºÍʵ±í

---

ÓÃÁÙʱ±í°É...

---

SQL code:


set @t_SQL='declare @t_tablebarcode table(id int
,barcode varchar(50)
,PackLayer int,SubTypeID int,PkgRatio