/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

1 vote185 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote193 views1 answer
Mysql get only the field names in a table
SQL
2 votes181 views2 answers
Mysql alter column default
SQL
1 vote190 views1 answer
Moodle query first user access
SQL
12 votes212 views6 answers
Change mysql root password
SQL
0 vote220 views2 answers
How to get max from each department in sql
SQL
3 votes196 views3 answers
Update con select postgresql
SQL
0 vote136 views1 answer
How to see the content of tables in pgadmin
SQL
2 votes164 views1 answer
Merge two columns in sql oracle
SQL
5 votes191 views5 answers
Find max number in sql
SQL