Breaking News: Grepper is joining You.com. Read the official announcement!

sql server union if table exist

Fafabulous answered on August 18, 2021 Popularity 3/10 Helpfulness 1/10

answer sql server union if table exist

sql server union if table exist

Comment

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

Popularity 3/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: sql sql-server union

Link to this answer
Share Copy Link