/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 vote356 views1 answer
Dump only data
SQL
0 vote365 views2 answers
While mysql
SQL
7 votes345 views2 answers
Html to react converter
SQL
22 votes370 views3 answers
Year format in date mysql
SQL
0 vote308 views1 answer
Split a string with expression and get the last value of split sql
SQL
1 vote351 views1 answer
Add multiple row table pl sql
SQL
1 vote351 views1 answer
What is int in mysql
SQL
0 vote331 views1 answer
Inser into example
SQL
0 vote450 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote424 views1 answer
How to check common records in 2 table
SQL