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 vote370 views1 answer
Sql join on a subquery
SQL
0 vote341 views1 answer
Psql no such file or directory
SQL
12 votes341 views3 answers
Duplicate a column in sql
SQL
0 vote344 views1 answer
The local psql command could not be located
SQL
2 votes429 views1 answer
Find column in all stored procedures sql server
SQL
57 votes597 views5 answers
How to create a new user in postgresql
SQL
5 votes369 views1 answer
Minecraft java port number
SQL
2 votes404 views2 answers
Mysql write into table
SQL
1 vote398 views2 answers
Truncate table sqlite
SQL
3 votes356 views1 answer
Mysql load sql from file
SQL