/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 vote297 views1 answer
Hue hive UploadingTextFiletoHive
SQL
7 votes276 views4 answers
Lowest salary in sql
SQL
0 vote286 views1 answer
Authentication modes in sql server
SQL
1 vote266 views1 answer
DATE_SUB postgres
SQL
0 vote265 views1 answer
Sql server roles and users
SQL
0 vote299 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
10 votes268 views5 answers
Mysql create user
SQL
1 vote280 views1 answer
Login to database mysql terminal
SQL
0 vote265 views1 answer
Sql clear table
SQL
1 vote255 views1 answer
Oracle convert run duration to number
SQL