>>Hi,
>>
>>I need to add a few fields to a SQL Server table:
>>MONTH_NO - Month number
>>MONTH_FR - Month from
>>MONTH_TO - Month to
>>In the VFP table, corresponding to this SQL Server table, the types of these fields are NUMERIC(2,0)
>>
>>Does it matter if in SQL Server I make the type of these field NUMERIC(2,0) vs INT?
>>
>>TIA
>
>As a follow-up to Naomi's reply...
>
>If it NEVER, repeat, NEVER will come close to 255, use tinyint
>
>I'd avoid Numeric(2,0). I can't give a compelling reason on the harm, but I'd still avoid it.
>
>Having said all of this, for things like MonthNumber, I typically use a char(2) and make it zero-filled ( '01', '02'....'10', '11', 12'). Part of the reason is to avoid any sorting nuances in reporting tools.
>
>Just my 2 cents
The Month number would never be more than 12, obviously. I have read somewhere (don't remember where exactly) that Numeric() is not to be used, unless absolutely required.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham