--表變數 update invent set goodInfo=null declare @tmp_goods table( gno char(5) ) insert into @tmp_goods select gno from invent group by gno declare @gno ... ...
--表變數 update invent set goodInfo=null declare @tmp_goods table( gno char(5) ) insert into @tmp_goods select gno from invent group by gno declare @gno char(6),@stno char(6),@gname varchar(255),@producer varchar(255) while exists(select gno from @tmp_goods) begin set rowcount 1 select @gno=gno from @tmp_goods select @gname=gname,@producer=producer from goods where gno=@gno; set rowcount 0 update invent set goodInfo=@gname+'-'+@producer where gno=@gno delete from @tmp_goods where gno=@gno end select * from invent
--臨時表 放在dbtemp資料庫中 if OBJECT_ID('tempdb.dbo.#tmp_inv','U') is not null drop table #tmp_invent 方法1: create table #tmp_inv(id int) --方法2 select * into #tmp_inv from invent