NUMERIC or INTEGER ?

Hi,
Is there any difference between NUMERIC and INTEGER datatype?
I am currently migrating my application from oracle to sqlserver hence i need to know the best equivalent:
Oracle
var_int int(38);
SQLServer:
@.var_int numeric(38) or @.var_integer integer
Please let me know the best equivalent
--SrikSrik
The basic different between numeric and interger is the size that u want to allocate to the fields

Just try to do this
--ERROR
create table test
(
p numeric(38),
x integer(38) --This will not table the width mean its fixed and it cannot be changed.
)
go

--CORRECT
create table test
(
p numeric(38),
x integer
)
go

and when u display the structure.

p numeric no 17 38 0 yes (n/a) (n/a) NULL
x int no 4 10 0 yes (n/a) (n/a) NULL
17 and 4 is the length of the field
38 and 10 is the precision of the fields respectively.

So it is better we use numeric instead of integer when converting Oracle to Sql server.

Hope this helps you|||Use integer in SQL Server for Oracle int. NUMBER is close to NUMERIC. Numeric implementation between Oracle and SQL Server is also slightly different. It has to do with storage and how we calculate precision/scale of resulting expression. It is best to understand those rules before using numeric otherwise you may get truncated or wrong results.|||thanks Dinesh and Umachandar for the info