/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 vote187 views1 answer
Sql examples from your work
SQL
0 vote191 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote191 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote204 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote197 views1 answer
Mysql terminal run sql file
SQL
1 vote252 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
1 vote157 views1 answer
Ms sql how to see active job current run time
SQL
1 vote269 views3 answers
Date_add mysql
SQL
4 votes194 views1 answer
Data types in sql
SQL
0 vote193 views1 answer
Insert overwrite table in mysql in nifi
SQL