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

-1 vote108 views1 answer
Export mysql table to file
SQL
0 vote158 views2 answers
Wordpress change url in database
SQL
1 vote151 views1 answer
Postgresql append array
SQL
6 votes102 views2 answers
Oracle
SQL
0 vote111 views1 answer
Mariadb cast to int
SQL
0 vote126 views1 answer
Gcloud sql list databases
SQL
0 vote124 views1 answer
Sql statement show all emails with dome
SQL
0 vote151 views1 answer
Do you know sql
SQL
0 vote228 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
19 votes117 views5 answers
Display table in sql
SQL