Thursday, March 8, 2012

Create New Table advice

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"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