SQL 2008存储过程的问题
/// ALTER proc [dbo].[getInbillMoney]
/// @no nvarchar(200)
/// --@temp nvarchar(200) output
/// as
/// declare @m numeric(12,4)
/// SET @m=(select SUM(costMoney) from InBill where inbillNO=@no)
/// return @m;
/// </summary>
/// <returns> </returns>
string getInbillMoney(string bill)
{
SqlConnection cn = LinkDB.LinkDBSqlconnection();
SqlCommand cmd = new SqlCommand("getInbillMoney",cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@no", SqlDbType.NVarChar).Value = bill;
SqlParameter a = cmd.Parameters.Add("@return_value",
SqlDbType.NVarChar);
a.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
string re = (string)(cmd.Parameters["@return_value"].Value.ToString());
return re;
}
上面的存储过程,用C#调用时怎么没有小数位呀(表中是有小数位的)