/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 vote142 views1 answer
Pl sql search saurce code
SQL
0 vote142 views1 answer
Why mysql is used?
SQL
0 vote135 views1 answer
Sql gap missing values
SQL
0 vote131 views1 answer
How to to get current date and time in sql
SQL
8 votes108 views1 answer
Oracle current date plus 1 month
SQL
2 votes162 views3 answers
Sql server reseed identity column
SQL
0 vote142 views1 answer
Disableforiegn key check
SQL
4 votes143 views1 answer
Find tables with column name in sql
SQL
-1 vote149 views2 answers
Full join sql
SQL
0 vote152 views1 answer
Mysql insert multiple rows based on select
SQL