你的sql语句是这样的:UPDATE LSB_fdqhdhz SET 'bdName' = 'kk' WHERE gzid = 'LSB00000000000'
应该是这样:alter PROCEDURE [dbo].[LSB_fdqhdhz_Update] @value varchar(50), @gzid varchar(50), @type varchar(50) as begin declare @sql nvarchar(600) set @sql = 'UPDATE LSB_fdqhdhz SET '+convert(nvarchar,@type)+' = '''+convert(nvarchar,@value)+''' WHERE gzid = '''+convert(nvarchar,@gzid)+'''' end exec(@sql)
set @sql = 'UPDATE LSB_fdqhdhz SET ' + @type + ' = ''' + @value + ''' WHERE gzid = ''' + @gzid + ''''
set @sql = 'UPDATE LSB_fdqhdhz SET ' + @type + ' = ''' + @value + ''' WHERE gzid = ''' + @gzid + ''''ALTER PROCEDURE [dbo].[LSB_fdqhdhz_Update] @value varchar(50), @gzid varchar(50), @type varchar(50) as begin declare @sql nvarchar(600) set @sql = 'UPDATE LSB_fdqhdhz SET ' + @type + ' = ''' + @value + ''' WHERE gzid = ''' + @gzid + '''' end exec(@sql)
改了之后调用的sql是这样: UPDATE LSB_fdqhdhz SET bdName = 'kk' WHERE gzid = 'LSB00000000000'
ALTER PROCEDURE [dbo].[LSB_fdqhdhz_Update] @value varchar(50), @gzid varchar(50), @type varchar(50) as begin declare @sql nvarchar(600) set @sql = 'UPDATE LSB_fdqhdhz SET '+convert(nvarchar,@type)+' = '''+convert(nvarchar,@value)+''' WHERE gzid = '''+convert(nvarchar,@gzid)+'''' end exec(@sql)
@value varchar(50),
@gzid varchar(50),
@type varchar(50)
as
begin
declare @sql nvarchar(600)
set @sql = 'UPDATE LSB_fdqhdhz SET '+convert(nvarchar,@type)+' = '''+convert(nvarchar,@value)+''' WHERE gzid = '''+convert(nvarchar,@gzid)+''''
end
exec(@sql)
@value varchar(50),
@gzid varchar(50),
@type varchar(50)
as
begin
declare @sql nvarchar(600)
set @sql = 'UPDATE LSB_fdqhdhz SET ' + @type + ' = ''' + @value + ''' WHERE gzid = ''' + @gzid + ''''
end
exec(@sql)
UPDATE LSB_fdqhdhz SET bdName = 'kk' WHERE gzid = 'LSB00000000000'
@value varchar(50),
@gzid varchar(50),
@type varchar(50)
as
begin
declare @sql nvarchar(600)
set @sql = 'UPDATE LSB_fdqhdhz SET '+convert(nvarchar,@type)+' = '''+convert(nvarchar,@value)+''' WHERE gzid = '''+convert(nvarchar,@gzid)+''''
end
exec(@sql)