/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 vote194 views1 answer
Mysql check if lowercase
SQL
-1 vote204 views3 answers
Compute age mysql
SQL
0 vote193 views1 answer
Test the postgresql db connection
SQL
5 votes179 views3 answers
How to remove unique key constraint in mysql
SQL
2 votes197 views1 answer
Oracle insert or update
SQL
0 vote215 views2 answers
How to truncate all table in mysql workbench
SQL
1 vote191 views1 answer
Sql into vs insert into
SQL
3 votes201 views3 answers
Mysql order by list
SQL
5 votes209 views2 answers
Get number of columns sql
SQL
11 votes195 views1 answer
Get ddl materialized view oracle
SQL