Sql server union if table exist

DECLARE @temp TABLE(empName varchar(100),empStoreNum varchar(100),empSales int,location varchar(20))
if object_id('table1') Is not null
insert into @temp
Select empName, empStoreNum, empSales, 'East' As SalesDistrict
FROM store1

if object_id('table2') is not null
insert into @temp
Select empName, empStoreNum, empSales, 'East' As SalesDistrict
FROM store2

if object_id('table3') is not null
insert into @temp
Select empName, empStoreNum, empSales, 'East' As SalesDistrict
FROM store3


select empName, empStoreNum, empSales,location
from @temp

Source: stackoverflow.com

Similar codes

0 vote158 views2 answers
Postgres another version
SQL
1 vote147 views1 answer
Sql myisam vs innodb
SQL
0 vote136 views1 answer
Sql examples from your work
SQL
-1 vote158 views1 answer
Auto increment psql not primary key
SQL
0 vote158 views1 answer
Grant access on table in oracle
SQL
4 votes164 views2 answers
Sql offset
SQL
1 vote132 views1 answer
Oracle compile schema
SQL
0 vote177 views1 answer
Table user postgres
SQL
2 votes175 views1 answer
Sql update \
SQL
0 vote191 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL