How do you persist enumerations in SQL Server?

This is one of those developer pulse questions. How do you prefer to persist values from an enumeration in your database? I've seen people suggest using its corresponding numeric value as well as a string.

And for those of you really looking to the future, how do you do it for SQL Server 2005? If I understand it right, since you can use your own types in the database, it sounds like a good idea to do just that. What I'm not sure of is how you deploy the enumeration from your humble dozen lines of code to something that lives in the database.


Comments have been disabled for this content.