27,579
社区成员
发帖
与我相关
我的任务
分享
--你 可以把存储过程修改成-那-样,其-中-特-别-的-是,@NeiRong-传-参-时-像-正-常-时-那-样-就-可-以-了,不用-特-殊-处-理
ALTER proc [dbo].[Formula_Lx_FieldNames]
@NeiRong varchar(40),
@bianh varchar(40),
@FieldNames varchar(40)
as
declare @s nvarchar(max)
SET @NeiRong=REPLACE(@NeiRong,'''','''''')
set @s = 'update Base_Formula_Lx_test set ' + @FieldNames + '=''' + @NeiRong + ''' where BianH=' + CAST(@bianh AS VARCHAR(10)) + ''
Exec(@s)
exec [dbo].[Formula_Lx_FieldNames] 'AA','BB','CC'
@s 结果是:update Base_Formula_Lx_test set CC=AA where BianH=BB
所以改为:
set @s = 'update Base_Formula_Lx_test set ' + @FieldNames + '=''' + @NeiRong + ''' where BianH=''' + @bianh + ''''