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 vote344 views1 answer
Sql delete row with auto increment
SQL
2 votes367 views3 answers
Row number mssql
SQL
1 vote339 views1 answer
Increase existing date in sql oracle
SQL
1 vote325 views3 answers
Remove unique key from a table
SQL
0 vote340 views1 answer
How to check even or odd in sql
SQL
0 vote339 views1 answer
Grouping by email domain mysql
SQL
0 vote375 views1 answer
Tinydb add table
SQL
22 votes345 views4 answers
Mysql reset auto increment id
SQL
5 votes384 views2 answers
Functions
SQL
0 vote387 views1 answer
Pl sql disable trigger
SQL