[原]SQL存储过程解决数据转换．．．ｊｕｓｔ　ｆｏｒｂａｎｋ

存储过程　@Last_balance_per_B Varchar(100)
select @Last_balance_per_B = cast(sum(last_balance) as varchar) from acc_data_table where years=@YEAR and monthe=＠month*3 and zhlx<>0 and acc_type='B' and substring(account,16,3)='001'
页面：
CmdSP.Parameters.Append CmdSP.CreateParameter("@Last_balance_per_B", adVarchar, adParamOutput,100)
即可获得没被截断或者四舍五入的余额数据．．．吧？
just test