SQL Server - validation of arbitrary configuration data
I'm storing "property values" in an SQL server db. "Property values" are linked to "Properties". "Properties" are linked to "property types". I need a way to validate "Property values" based on the "property types" of thei开发者_运维问答r "properties".
Currently, I'm storing a regex for validation on the "property types" table.
Is there a better way?
精彩评论