臨時表變量的用法

 declare @sql varchar(5000)
begin
set @sql=' select   id  from address_book '
set @sql='insert into @table '+@sql
set @sql='declare @table table  ( uid int identity(1,1),   id varchar(50) )  declare @maxid int '+@sql
set @sql=@sql+'   select @maxid=max(uid) from @table'
set @sql=@sql+' declare @i int  declare @id varchar(50)  set @i=1'

set @sql=@sql+' delete from user_param '
set @sql=@sql+' while @i<=@maxid begin '
set @sql=@sql+' print(@i) select @id=id from @table where uid=@i print(@id) '
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''maxRowPtrPage'',''20'',''每頁顯示之最大列數'',@id)'
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''listStyle'',''normal'',''顯示模式(條列式, 報表式)'',@id)'
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''language'',''chinese'',''語言'',@id)'
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''weather'',''show'',''首頁加載天氣預報'',@id)'
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''msgbox'',''關閉'',''右下角消息框提醒'',@id)'
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''leftTree'',''show'',''加載樹形結構'',@id)'
set @sql=@sql+' insert into user_param(name,content,description,emp_id) values(''bbs'',''24'',''公務交流區醒目時間范圍'',@id)'
set @sql=@sql+' set @i=@i+1  end'
exec(@sql)
end