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 vote268 views2 answers
How to use aggregate functions in sql
SQL
0 vote288 views1 answer
Get statis values sql
SQL
0 vote274 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
18 votes266 views6 answers
Create table mysql
SQL
1 vote302 views1 answer
Concat first name and last name in mysql
SQL
2 votes286 views3 answers
Sql truncate table
SQL
15 votes276 views4 answers
Mysql where value is null
SQL
0 vote255 views1 answer
Initcap in sql
SQL
1 vote267 views1 answer
Oracle sql listagg
SQL
0 vote220 views1 answer
Mysql convert column to uppercase
SQL