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 vote106 views4 answers
How to drop all tables in sql
SQL
4 votes113 views1 answer
Select nls_date_format
SQL
7 votes115 views6 answers
Nth highest salary in sql
SQL
0 vote148 views1 answer
How to make sure two tables have same exact data in sql
SQL
16 votes150 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
6 votes107 views1 answer
Allsource oracle
SQL
0 vote115 views1 answer
Sql values not in another table
SQL
0 vote81 views2 answers
Sql query unique
SQL
2 votes122 views1 answer
Oracle apex list connected users
SQL
0 vote71 views1 answer
Delete all rows from table sqlite
SQL