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 vote229 views1 answer
How do you insert boolean to postgresql
SQL
3 votes224 views2 answers
Get current year sql
SQL
11 votes229 views3 answers
Pl sql example
SQL
2 votes229 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
1 vote243 views1 answer
Connect to mysql database ubuntu
SQL
0 vote206 views1 answer
A network or instance-specific error sql server
SQL
1 vote215 views2 answers
How to enable error squiggles in vs code
SQL
3 votes231 views1 answer
DB: in eloquent using sql
SQL
0 vote212 views1 answer
Oracle create table auto generated primary key
SQL
0 vote227 views1 answer
SQL add a totals of differemt rows of the same id
SQL