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 vote287 views1 answer
Multiple like values for single column postgres
SQL
2 votes266 views1 answer
Oracle cpu per session
SQL
0 vote284 views1 answer
Kill a pid redshift
SQL
0 vote272 views2 answers
Python mysql create table if not exists
SQL
1 vote245 views1 answer
Full text index mysql
SQL
7 votes285 views2 answers
What is sql clause
SQL
0 vote276 views1 answer
Sql server size of every table in a db
SQL
5 votes277 views1 answer
Purge undo tablespace oracle 11g
SQL
3 votes308 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
1 vote281 views1 answer
Sql server datetime vs datetime2
SQL