>>>>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.
>
>
>create table #xxt ("tinyint" tinyint)
>insert into #xxt values (0)
>insert into #xxt values (255)
>select * from #xxt
>drop table #xxt
>GO
>
>create table #xxt ("NUMERIC(2,0)" NUMERIC(2,0))
>insert into #xxt values (-9)
>insert into #xxt values (99)
>select * from #xxt
>drop table #xxt
>GO
>
>create table #xxt ("int" int)
>insert into #xxt values (0xF0000000)
>insert into #xxt values (0x0FFFFFFF)
>select * from #xxt
>drop table #xxt
>GO
>
>MartinaJ
I am sorry but I don't understand what the above script should "prove/indicate" to me? I run it and see the results but how should I interpret them?
"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