KuldipMCA KuldipMCA - 1 year ago 90
SQL Question

How to define ENUM in SQL Server 2005?

Possible Duplicate:

Does SQL Server 2005 have an equivalent to MySql’s ENUM data type?

Is there any way to define ENUM in SQL Server 2005?

I have fixed values which I need to use in procedures and functions.

gbn gbn
Answer Source

Use one or more scalar UDFs?

One per constant:

  • dbo.CONST_Bicycle returns 1
  • dbo.CONST_Car returns 2

One per enum:

  • dbo.CONST_Types('Bicycle') returns 1
  • dbo.CONST_Types('Car') returns 2

Or use a table with ID, Name per enum

Use a client side enum to match this (perhaps with validation against the table solution)

There is no quick or clean way to do this like there is in .net (as per your comment).

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download