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)

Real time use of cross join.