Sql Server临时表和游标的使用小结

use pubs
go
select  into #tem from jobs

SELECT  FROM [tempdb].[dbo].[sysobjects] 
where xtype='u' 

if object_id('tempdb..#tem') is not null 
begin 
 print 'exists' 
end 
else 
begin 
 print 'not exists' 
end 

exec('select  into #tems from jobs')
select  from #tems

if CURSOR_STATUS('global','游标名称') =-3 and CURSOR_STATUS('local','游标名称') =-3 
begin 
 print 'not exists' 
end
SELECT  FROM [tempdb].[dbo].[sysobjects] where xtype='u' 

if object_id('tempdb..#tem') is not null 
begin 
 print 'exists' 
end 
else 
begin 
 print 'not exists' 
end 

exec('select  into #tems from jobs')
select  from #tems

if CURSOR_STATUS('global','游标名称') =-3 and CURSOR_STATUS('local','游标名称') =-3 
begin 
 print 'not exists' 
end
SELECT  FROM [tempdb].[dbo].[sysobjects] where xtype='u' 

if object_id('tempdb..#tem') is not null 
begin 
 print 'exists' 
end 
else 
begin 
 print 'not exists' 
end 

exec('select  into #tems from jobs')
select  from #tems

if CURSOR_STATUS('global','游标名称') =-3 and CURSOR_STATUS('local','游标名称') =-3 
begin 
 print 'not exists' 
end