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

3 votes349 views2 answers
Create schema postgres
SQL
0 vote340 views2 answers
Mysql unique two columns
SQL
0 vote357 views2 answers
Add colum in sql
SQL
1 vote373 views1 answer
Login to database mysql terminal
SQL
2 votes384 views1 answer
How to check if a row is null in sql
SQL
0 vote329 views2 answers
What is 1=2 in sql
SQL
1 vote365 views1 answer
How to use db.execute
SQL
0 vote308 views1 answer
Sql random decimal
SQL
1 vote341 views1 answer
Sysdate in sql
SQL
-1 vote348 views1 answer
Module operator in oracle sql
SQL