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

10 votes103 views1 answer
Oracle view dependencies
SQL
0 vote114 views1 answer
Select lowest values sql
SQL
-1 vote120 views1 answer
Adding a new table psql
SQL
0 vote106 views2 answers
Dbms interview questions
SQL
0 vote109 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote97 views1 answer
Drush sql-dump
SQL
1 vote131 views2 answers
Mysql does sentance contain word
SQL
6 votes112 views1 answer
Oracle rank
SQL
5 votes95 views1 answer
Ora-00054 find lock
SQL
3 votes107 views1 answer
Pl sql escape &
SQL