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 vote198 views1 answer
Qt qsql check if table exist
SQL
0 vote199 views1 answer
Apex for oracle 11g
SQL
0 vote206 views1 answer
Sql database connectivity
SQL
2 votes206 views2 answers
Mysql add hours to time field
SQL
0 vote216 views1 answer
Mysql delete from where like
SQL
0 vote154 views1 answer
Copy data from cell to cell mysql
SQL
0 vote193 views1 answer
Sql server set complex constraints
SQL
-1 vote177 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
2 votes234 views1 answer
Remove foreign key constraints in postgres
SQL
42 votes268 views6 answers
Sql query duplicate rows
SQL