在存储过程中执行SQL字符串并存入全局临时表

@Begin int, 
@Ending int
AS
declare @sSql varchar(500),@sStr varchar(500)
set @sSql= '(select * from titles where title_id is not null '
if @Begin ='1'
 set @sSql=@sSql+'and pub_id=''0877'''
if @Ending <>''
 set @sSql=@sSql+'and type=''mod_cook'''
set @sSql=@sSql + ') temp'

set @sStr='select * into ##bb from'+ (@sSql)
exec(@sStr)
select * into #temp from ##bb 
drop table ##bb--一定要销毁全局临时表

——##标识全局临时表，#标识局部临时表