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

8 votes139 views1 answer
Similarities between ddl and dml
SQL
4 votes227 views3 answers
Postgres drop all tables
SQL
1 vote170 views1 answer
Rails run native ssql query
SQL
0 vote160 views1 answer
How to connect postgresql database with java
SQL
9 votes181 views3 answers
Mysql run sql file
SQL
6 votes180 views2 answers
Oracle trigger
SQL
4 votes226 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote135 views1 answer
Count char in java
SQL
0 vote184 views1 answer
Mysql grouping functions
SQL
27 votes215 views6 answers
Sql update record
SQL