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 vote121 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote126 views1 answer
Insert into select with group by
SQL
0 vote114 views1 answer
Postgres week number
SQL
0 vote108 views1 answer
Is numeric in sql
SQL
0 vote111 views1 answer
Create table employees oracle
SQL
0 vote122 views1 answer
Excel export from sql using python
SQL
5 votes130 views4 answers
SQL Order of execution
SQL
0 vote110 views2 answers
Mysql regexp match word
SQL
0 vote118 views1 answer
Get all employees if name ends with in sql
SQL
0 vote116 views1 answer
Top frequency in sql server
SQL