[help]求一个SQL

Question

select goodsID,goodsName,quantity,price,'2005060200002ADC' as bjdID into #t from goods_tbl where bjdID='2005060200001ADC'

Answer 1

试试这样行不行：
insert into goods_tbl(goodsID,goodsName,quantity,price,bjdID)
select goodsID,goodsName,quantity,price,'2005060200002ADC' 
from goods_tbl 
where bjdID='2005060200001ADC'

Answer 2

select goodsid,goodsname,quantity,price,replace(bjdid,'2005060200001ADC','2005060200002ADC') bjdid 
into #table from goods_tbl