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

10 votes165 views2 answers
What is database
SQL
1 vote140 views1 answer
Sql insert for each distinct value
SQL
103 votes390 views2 answers
Sql server LIKE '%%'
SQL
21 votes152 views5 answers
Oracle all tables
SQL
0 vote196 views1 answer
Offset in postgresql example
SQL
0 vote161 views3 answers
Duplicate row mysql
SQL
1 vote102 views1 answer
Postgresql last element of array
SQL
0 vote147 views1 answer
Qt qsql check if table exist
SQL
0 vote172 views1 answer
Varchar format not case sensitive sql
SQL
0 vote137 views1 answer
Database springboot
SQL