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 vote139 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote139 views1 answer
Denied
SQL
1 vote166 views2 answers
Sql now - 1 day
SQL
0 vote156 views1 answer
Java check if something is in mysql table
SQL
0 vote140 views1 answer
Flask sqlalchemy update row
SQL
1 vote157 views2 answers
Foreign key set 0
SQL
21 votes145 views1 answer
Cheatsheet for sql
SQL
0 vote148 views1 answer
Mysql terminal list table
SQL
0 vote160 views1 answer
SQLServerException.makeFromDatabaseError
SQL
5 votes180 views1 answer
Migrate sql table another database
SQL