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

1 vote92 views1 answer
How to run sql script
SQL
0 vote237 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
3 votes142 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
2 votes128 views1 answer
Mysql how to store lat,lng
SQL
2 votes147 views1 answer
Sql server find columns list in tables
SQL
0 vote133 views1 answer
How to check even or odd in sql
SQL
0 vote134 views1 answer
Mysql url
SQL
0 vote125 views1 answer
Find largest table in mysql database
SQL
1 vote216 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote95 views1 answer
Mysql find foreign key references
SQL