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 vote309 views1 answer
Add sqlite3 in lumen
SQL
7 votes318 views1 answer
Minecraft forge server host
SQL
15 votes345 views4 answers
Mysql where value is null
SQL
0 vote329 views1 answer
Mysql shell ERROR: Not connected.
SQL
13 votes330 views1 answer
Select count of distinct values sql
SQL
1 vote311 views1 answer
Mysql connect command
SQL
1 vote356 views3 answers
How to pass password to mysql command line
SQL
0 vote320 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote338 views1 answer
Query by column for substring sql
SQL
2 votes324 views1 answer
Sql missing records from another table
SQL