numeric data type

  • Thread starter Thread starter Mike P
  • Start date Start date
M

Mike P

I am using a stored procedure to get a value from a table, but the
parameter I need to pass is a numeric data type in the table. The SQL
Parameter object in .NET seems to support most of the SQL Server data
types, but not numeric. Can anybody tell me what data type I need to
use?


Any help would be really appreciated.


Cheers,

Mike
 
I am using a stored procedure to get a value from a table, but
the parameter I need to pass is a numeric data type in the
table. The SQL Parameter object in .NET seems to support most
of the SQL Server data types, but not numeric. Can anybody tell
me what data type I need to use?
Click to expand...

Mike,

In SQL Server, the decimal and numeric types are equivalent. In
..Net, use SqlDbType.Decimal.
 
Back
Top