IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t
create table #t ( test int)
GO
insert into #t(test) select 100 as test
GO 100
select * from #t
IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t create table #t ( test int) GO insert into #t(test) select 100 as test GO 100 ![]() |