/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

2 votes314 views1 answer
Oracle cpu per session
SQL
0 vote325 views1 answer
Tsql find procedure with name
SQL
0 vote327 views1 answer
Equi joins in oracle
SQL
0 vote328 views1 answer
Codigo crear tablas sql server
SQL
0 vote314 views1 answer
MySQL error code 2068
SQL
0 vote287 views2 answers
How to combine two sql queries in one result
SQL
0 vote352 views2 answers
Mysql calcular idade
SQL
16 votes361 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote326 views1 answer
Get the First and Last Word from a String or Sentence
SQL
2 votes357 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL