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 vote175 views1 answer
Create domain sql
SQL
0 vote127 views1 answer
Now() -1 mysql
SQL
0 vote171 views1 answer
Renommer table sql
SQL
6 votes219 views2 answers
WHERE value IS sql
SQL
0 vote163 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote172 views1 answer
Mysql dump everythign
SQL
5 votes193 views3 answers
Show indexes mysql
SQL
1 vote182 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote198 views1 answer
Sql get latest of 2 datetimes
SQL
50 votes264 views6 answers
Install mysql on ubuntu
SQL