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 vote165 views1 answer
Oracle list all stored procedures
SQL
0 vote195 views1 answer
Oracle execute immediate quotes
SQL
1 vote232 views1 answer
Myql find duplicates
SQL
0 vote186 views1 answer
Postgres get running query
SQL
0 vote200 views1 answer
Openquery insert into linked server
SQL
-1 vote192 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
18 votes197 views3 answers
Mysql query add column with default string value
SQL
0 vote214 views2 answers
Nested query
SQL
0 vote204 views1 answer
Ms sql database data size
SQL
0 vote194 views1 answer
Mysql select last 15 minutes
SQL