Vinay Talapaneni

Vinay Talapaneni

  • 1.9k
  • 226
  • 80.9k

Can i execute my code without error.

Aug 31 2020 8:18 AM
if exists(select top 1 1 from sys.tables where name = '#table1')
drop table #table1
create table #table1(id int)
if exists(select top 1 1 from sys.tables where name = '#table1')
drop table #table1
create table #table1(id int)
select * from #table1

Answers (5)