>>>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