[email protected]，@changeField要改变值的字段，@stateValue要改变的值，@whereStr 求详细储存啊，各位高手教教我
------解决方案--------------------
[email protected]，@stateValue要改变的值” 拼接好啊，因为你改的可能是多个字段
- C# code
CREATE PROCEDURE dbo.aa_updatedata( @strTbName nvarchar(50), @strFldContent nvarchar(4000), @strCondition nvarchar(1000), @strMsg nvarchar(200) output)asset nocount on set ansi_nulls off declare @iCount int, @iError intdeclare @strTmp nvarchar(4000)set @strTmp=''set @strMsg=''--更新数据 if @strCondition is null or @strCondition='' set @strTmp='update [email protected]+' set [email protected]else set @strTmp='update [email protected]+' set [email protected]+' where [email protected]exec sp_executesql @strTmpset @iError=@@errorif @iError<>0begin if @iError=547 set @strMsg='保存失败！您所选择的信息已被其他用户删除，请重新选择！' else set @strMsg='保存失败！输入内容太长，请重新输入！' return -1endset @strMsg='保存成功！'return 0GO