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 vote146 views1 answer
Connect to ssms with python
SQL
0 vote142 views1 answer
Mysql join column order By and group By
SQL
0 vote123 views1 answer
Uuid sqlalcomany
SQL
5 votes132 views2 answers
Mysql drop table cascade
SQL
1 vote124 views1 answer
Mysql average of multiple columns
SQL
0 vote133 views1 answer
Download mysql database to excel in android studio
SQL
0 vote138 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
11 votes129 views3 answers
Change column name sql server management studio
SQL
0 vote140 views1 answer
Get who is hired in february in sql
SQL
0 vote129 views1 answer
Mysql bash execute sql file
SQL