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

1 vote205 views1 answer
Psql connect
SQL
0 vote196 views1 answer
Create table with float datatype in sql server
SQL
1 vote187 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
1 vote190 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote208 views1 answer
Mysql sql.gz
SQL
8 votes198 views1 answer
Database backup in mysql server recovery
SQL
0 vote185 views1 answer
Sql character index
SQL
4 votes184 views1 answer
Oracle table statistics last analyzed
SQL
0 vote181 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
13 votes188 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL