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 vote161 views1 answer
Create query in where clasue
SQL
1 vote140 views1 answer
How to update date add hours in postgresql
SQL
4 votes157 views3 answers
Is not null sql
SQL
2 votes143 views1 answer
Sqlite show table indexes
SQL
-1 vote151 views4 answers
Restart mysql server ubuntu
SQL
0 vote134 views1 answer
Set column width in sqlplus
SQL
0 vote170 views1 answer
Delete a temporary table mysql
SQL
3 votes170 views2 answers
How to modify rows in SQL Server
SQL
1 vote159 views1 answer
Insert value to new table by joining 2 different tables
SQL
31 votes155 views4 answers
How to get duplicate records with multiple field in sql
SQL