/SQL/How to display enum value sql server

How to display enum value sql server

CREATE TABLE [dbo].[StatusLookup](
    [StatusID] [int] NOT NULL,
    [StatusName] [varchar](64) NOT NULL,
    [StatusDescription] [varchar](max),
)

INSERT INTO [dbo].[StatusLookup]([StatusID],[StatusName],[StatusDescription]
VALUES(1, 'Dispatched', 'A dispatched record')
...

Source: stackoverflow.com

How to display enum value sql server

SELECT StatusLookup.[StatusName], 
COUNT(Delivery.DeliveryID) AS Dispatched_Status 
FROM Delivery 
JOIN StatusLookup ON Delivery.Status = StatusLookup.StatusID
WHERE StatusLookup.[StatusName] = 'Dispatched'
GROUP BY StatusLookup.[StatusName];

Source: stackoverflow.com

Similar codes

0 vote361 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote351 views1 answer
Md5 encryption for existing records
SQL
0 vote331 views1 answer
Soql more than today
SQL
0 vote288 views1 answer
Mysql select top 2
SQL
9 votes602 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote418 views1 answer
Mariadb change column type
SQL
3 votes365 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote348 views2 answers
How to tun mysql on ubunto
SQL
0 vote411 views3 answers
Postgres trim string
SQL
2 votes316 views3 answers
Mysql cheat sheet
SQL