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

7 votes121 views3 answers
Sql update where id
SQL
1 vote137 views1 answer
Show table status command in mysql
SQL
1 vote131 views1 answer
Minus vs intersect in sql
SQL
0 vote126 views1 answer
Sql if else in select
SQL
12 votes129 views1 answer
How to change the value of a table in sql
SQL
4 votes127 views2 answers
Oracle drop job
SQL
1 vote133 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote173 views1 answer
Restart serial number for postgres
SQL
0 vote129 views1 answer
Laravel eloquent get generated sql
SQL
5 votes121 views4 answers
Mysql update column with value from another table
SQL