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 vote267 views4 answers
Best data type to represent money in mysql
SQL
7 votes271 views1 answer
Set sequence value oracle
SQL
0 vote272 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
2 votes272 views1 answer
Mysql virtual column
SQL
31 votes287 views4 answers
Mysql grant execute
SQL
0 vote262 views1 answer
Mysqlimport
SQL
1 vote279 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote273 views1 answer
List column names of multiple tables psql
SQL
0 vote301 views1 answer
How do I insert a blob in SQL?
SQL
4 votes289 views1 answer
Data types in sql
SQL