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 vote130 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
1 vote131 views1 answer
What is intersect
SQL
0 vote140 views1 answer
PSQL qith variables
SQL
1 vote152 views1 answer
Join to find results not in another table
SQL
18 votes140 views6 answers
Mysql create table
SQL
0 vote130 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote138 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote163 views1 answer
Where field is null sql knex
SQL
0 vote167 views1 answer
How to find unique element in sql
SQL
0 vote140 views1 answer
Write a query to peint the pattern P(20)
SQL