M
Mikael Engdahl
Hello
I am calling a stored procedure in a SQL Server 2000 like this:
<code>
SqlCommand cmd = new SqlCommand("Sproc", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Param", SqlDbType.Decimal).Value = amount;
SqlDataReader reader = cmd.ExecuteReader();
</code>
/amount/ is decimal with the value 0.1, but when I check the
database it contains 0.
Why?
(The field and the sproc both use DECIMAL).
I am calling a stored procedure in a SQL Server 2000 like this:
<code>
SqlCommand cmd = new SqlCommand("Sproc", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Param", SqlDbType.Decimal).Value = amount;
SqlDataReader reader = cmd.ExecuteReader();
</code>
/amount/ is decimal with the value 0.1, but when I check the
database it contains 0.
Why?
(The field and the sproc both use DECIMAL).