22,211
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
create PROCEDURE [dbo].[spUpdateItems]
@LogId int,
@Result varchar(10),
@ItemNo varchar(10)
AS
declare @sqlString nvarchar(100)
set @sqlString = 'update TableName set Item'+ltrim(@ItemNo)+' = ''' + @Result +''' where Id='+ltrim(@LogId)
exec (@sqlString)
go
应该这样,再试一下。create PROCEDURE [dbo].[spUpdateItems]
@LogId int,
@Result varchar(10),
@ItemNo varchar(10)
AS
declare @sqlString nvarchar(100)
set @sqlString = 'update TableName set '+ltrim(@ItemNo)+' = ' + @Result +' where Id='+ltrim(@LogId)
exec (@sqlString)
go
create PROCEDURE [dbo].[spUpdateItems]
@LogId int,
@Result varchar(10),
@ItemNo varchar(10)
AS
declare @sqlString nvarchar(100)
set @sqlString = 'update TableName set Item'+ltrim(@ItemNo)+' = ' + @Result +' where Id='+ltrim(@LogId)
exec (@sqlString)
go
create PROCEDURE [dbo].[spUpdateItems]
@LogId int,
@Result varchar(10)
AS
declare @sqlString nvarchar(100)
set @sqlString = 'update TableName set Item = ' + @Result +' where Id='+ltrim(@LogId)
exec (@sqlString)
go
改成这样。