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 vote276 views1 answer
How to insert same table data using mysql query
SQL
0 vote330 views1 answer
Pl sql disable trigger
SQL
13 votes306 views2 answers
Sqlite rename table
SQL
-1 vote295 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
16 votes341 views1 answer
Sqlserver add column to table
SQL
1 vote277 views1 answer
Set statiscis on in sql server
SQL
0 vote325 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote315 views1 answer
Myql find duplicates
SQL
1 vote300 views1 answer
Woocommerce mysql price table
SQL
0 vote345 views1 answer
Mariadb change column type
SQL