simfee,simpay 这两个字段数据库里是不是用MONEY类型了?
你的INSERT语句有问题,'+ @mfee +'这样的值怎么可能转换成MONEY。改用:
INSERT INTO InvoiceMain (siminvid,simsup,simstate,simrecorder,simbackinvid,simtime,simcomment,simsum,simpreferential,simfee,simpay )
values ( @did , @supid , @state , @user , @backinvid ,@timestr ,@comment , @msum , @mpreferential , @mfee , @mpay )
你的INSERT语句有问题,'+ @mfee +'这样的值怎么可能转换成MONEY。改用:
INSERT INTO InvoiceMain (siminvid,simsup,simstate,simrecorder,simbackinvid,simtime,simcomment,simsum,simpreferential,simfee,simpay )
values ( @did , @supid , @state , @user , @backinvid ,@timestr ,@comment , @msum , @mpreferential , @mfee , @mpay )
INSERT INTO InvoiceMain (siminvid,simsup,simstate,simrecorder,simbackinvid,simtime,simcomment,simsum,simpreferential,simfee,simpay )
values ( @did , @supid , @state , @user , @backinvid ,@timestr ,@comment , @msum , @mpreferential , Cast(@mfee As Money) ,Cast(@mpay As Money))如果还有Money类型,做同样的转换。