scale. What is the best way to name the columns? Here is some sample
rows with data.
------------
DPT_CODE_1 | 300 | 121 | 120 | 61 | 60
DPT_CODE_2 | 360 | 241 | 240 | 121 | 120
Thanks for any advice.
Aplatfl"aplatfl" <aplatfl@.bellsouth.net> wrote in message
news:1141139056.502543.249810@.z34g2000cwc.googlegr oups.com...
> I am creating a table that will store my companys annual punctuality
> scale. What is the best way to name the columns? Here is some sample
> rows with data.
Umm, name the columns based on what they represent.
The following rows don't have any meaning to them.
I mean I could simply name them: Code, Number1, Number2, Number3, Number4,
Number5 but that's not very useful.
> ------------
> DPT_CODE_1 | 300 | 121 | 120 | 61 | 60
> DPT_CODE_2 | 360 | 241 | 240 | 121 | 120
> Thanks for any advice.
> Aplatfl|||1.Avoid reserved words
2.singular or plural , it probably doesn't matter
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"aplatfl" <aplatfl@.bellsouth.net> wrote in message
news:1141139056.502543.249810@.z34g2000cwc.googlegr oups.com...
> I am creating a table that will store my companys annual punctuality
> scale. What is the best way to name the columns? Here is some sample
> rows with data.
> ------------
> DPT_CODE_1 | 300 | 121 | 120 | 61 | 60
> DPT_CODE_2 | 360 | 241 | 240 | 121 | 120
> Thanks for any advice.
> Aplatfl
No comments:
Post a Comment