Does anyone know if Sql Server 2005 supports a similar set of values like a C# enum? I don't want to have to create a table for 4 lookup values (e.g cricital, high, medium and low).
Sql Server 2005 Enum Values?
Well I am not sure about SQL Server 2005, but the primitive way which I can think of is to define your field as VARCHAR and impose a CHECK constraint on it to make sure only one of the lookup values you mentioned are entered.
I think you might also benefit from a user defined type here.
Hope this helps.
Reply:Relation database stores data in a single form - a table.
How shall you use these values?
You can use client application for specific purpose.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment