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

5 votes331 views1 answer
Oracle asynchronous procedure
SQL
1 vote368 views1 answer
Psql connections
SQL
51 votes593 views6 answers
Opera gx
SQL
0 vote349 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote335 views1 answer
What are the aggregate function in sql
SQL
3 votes379 views2 answers
How to open postgresql in windows
SQL
1 vote347 views1 answer
Mysql is odd
SQL
2 votes373 views3 answers
Postgres create view
SQL
0 vote341 views1 answer
Can sqldatareader be null
SQL
0 vote374 views1 answer
How to delete duplicate rows in oracle
SQL