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 vote181 views1 answer
Mysql select statement after index
SQL
0 vote208 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote187 views1 answer
Drop constraint in ms sql
SQL
0 vote190 views1 answer
Sql server cannot create database diagram
SQL
1 vote214 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote205 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote212 views1 answer
Sql on-premises
SQL
0 vote191 views1 answer
Insert set mysql
SQL
27 votes332 views3 answers
Mysql delete row
SQL
0 vote188 views1 answer
Execut sql python
SQL