>>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
>
>VFP NUMERIC(2,0) is equal to MS SQL NUMERIC(2,0) - store in two bytes (characters)
>VFP INT is equal to MS SQL INT - store in four bytes (binary)
>
>MartinaJ
Thank you, Martina. I am not concerned with the number of bytes these fields take. The table is not very big.
And I read your message as there is NO downside in making these fields' type NUMERIC(2,0) in SQL Server.
"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