I need to use sets in standard SQL. I need describe column type like selection from set of something (Example Color=[Red, Green, Blue] )
. I can use check constrain or create lookup table with tree records - Red,Green,Blue. What are pluses and minuses of each method. I need to make this solution universal and use in much as possible SQL servers.
Aucun commentaire:
Enregistrer un commentaire