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 vote250 views1 answer
How to fetch data from database in sql
SQL
4 votes270 views2 answers
DB::transaction
SQL
0 vote210 views1 answer
Get the Db column names from a SqlDataReader
SQL
1 vote284 views1 answer
Sql oracle update multiple rows
SQL
0 vote250 views1 answer
Selecting from a view SQL
SQL
1 vote215 views2 answers
Sql where keyword
SQL
0 vote194 views1 answer
Oracle archivelog usage
SQL
0 vote221 views1 answer
How to create a table in sql stack overflow
SQL
1 vote202 views1 answer
Oracle list constraints
SQL
0 vote206 views1 answer
Ksql quickstart docker
SQL