/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

11 votes333 views2 answers
Import mysql dump command line windows
SQL
0 vote213 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote226 views1 answer
Oracle user last connection date
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
0 vote200 views1 answer
How to update sql server version
SQL
0 vote200 views1 answer
Providername system.data. mysql
SQL
0 vote197 views1 answer
Pl sql search saurce code
SQL
1 vote211 views1 answer
Sql server kill all connections
SQL
0 vote209 views1 answer
How to display value of variable in mysql
SQL
0 vote276 views1 answer
What does the -p flag do in mysql cli
SQL