Create a global variable list/set in sql server

Question

DECLARE @Companies_List char(25)
SET @Companies_List = ('Amazon','Google','Facebook')

select * 
from companies
where name in @Companies_List

I'm new to SQL Server. I'm trying to create a global set containing the values that I want to use in the SQL where clause, but apparently the above script wouldn't work. Any idea how I should do it? Many thanks!

The table variable answer is a good idea. The table definition matches the variable you declared as char(25). I would recommend using varchar(25) instead. — Morpheus
– Morpheus, Commented Oct 6, 2015 at 18:23

Siyual · Accepted Answer · 2015-10-06 18:18:00Z

3

I would create a TABLE variable and do a JOIN to it for a list like this:

DECLARE @Companies_List TABLE 
(
    Name Char(25)
)

INSERT  @Companies_List (Name)
VALUES  ('Amazon'), ('Google'), ('Facebook')

SELECT  C.*
FROM    Companies       C
JOIN    @Companies_List CL  ON  C.Name = CL.Name

If you want something more concrete, you should make a physical TABLE.

answered Oct 6, 2015 at 18:18

Siyual

17k8 gold badges47 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Create a global variable list/set in sql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related