declare @sql varchar (100)
select @sql = 'update '+tablename + ' set '+ fieldname + ' = '+ fieldname + ' + 1' + 'where ...'exec (@sql)
select @sql = 'update '+tablename + ' set '+ fieldname + ' = '+ fieldname + ' + 1' + 'where ...'exec (@sql)
@table varchar(100),
@field varchar(200)
as
declare @sql varchar (100)
select @sql = 'update '+@table + ' set '+ @field + ' = '+ @field + ' + 1'
exec(@sql)
@table varchar(100),
@field varchar(200)
as
declare @sql varchar (100)
select @sql = 'update '+@table + ' set '+ @field + ' = '+ @field + ' + 1'
exec(@sql)
goexec proc_control 'tableName', 'FieldName'exec proc_control @table = 'tableName', @field = 'FieldName'