>>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
>
>Use TinyInt for this.
>
>
https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sqlWhat advantage (other than smaller storage) the tinyint would have vs. NUMERIC(2,0)?
"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