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 vote310 views1 answer
Java mysql date format
SQL
0 vote324 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
6 votes326 views2 answers
Sql display max value
SQL
42 votes439 views6 answers
Rename table sql server
SQL
16 votes340 views4 answers
Find duplicates mysql
SQL
0 vote338 views1 answer
Sql tablo sp
SQL
1 vote328 views1 answer
Oracle create index if not exists
SQL
9 votes325 views3 answers
Oracle undo usage by session
SQL
0 vote324 views1 answer
Number(10 2) in sql means
SQL
0 vote319 views1 answer
Mysql get 2nd value in comma separated list
SQL