Insert default value to SQL select statment

Question

I need to insert a default value to my select statement So I am doing it in this fashion.

Is there any better way I can do this?

I need to insert "All" as my first row value to table Sitetbl select statement.

 DECLARE @SiteValue TABLE  
 (  
    Id INT IDENTITY(1,1),  
    SiteID Nvarchar(15),  
    SiteName Nvarchar(100)  
 )  

 Insert into  @SiteValue(SiteID,SiteName) values('All','All')

 insert into  @SiteValue(SiteID,SiteName) 

 SELECT  DISTINCT  SiteID,SiteName from Sitetbl

Ex: Result how I am looking

All  All
St   Singapore
IN   India
CH   China

PSK · Accepted Answer · 2018-03-27 12:50:26Z

1

You can simplify it like following.

insert into @SiteValue(SiteID,SiteName)
SELECT 'All' SiteID,'All' SiteName 
UNION
SELECT DISTINCT SiteID,SiteName from Sitetbl

answered Mar 27, 2018 at 12:50

PSK

18k5 gold badges35 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tab Alleman · Accepted Answer · 2018-03-27 12:49:05Z

0

No. There are other ways, such as using a UNION ALL in your SELECT, but they are not "better" than the way you are doing it now.

answered Mar 27, 2018 at 12:49

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

Comments

Alexander Volok · Accepted Answer · 2018-03-27 13:16:13Z

0

Perhaps, introduction of the view:

CREATE VIEW SitetblWithDefault
AS
SELECT 'All' SiteID,'All' SiteName 
UNION ALL
SELECT  SiteID,SiteName from Sitetbl

So, all selects of this view will have Default value just before other values

edited Mar 27, 2018 at 13:16

answered Mar 27, 2018 at 13:10

Alexander Volok

5,9903 gold badges19 silver badges34 bronze badges

Collectives™ on Stack Overflow

Insert default value to SQL select statment

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related