>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