存储过程update吧 sql语句拼接（列是动态参数）

    SET @filed = ( SELECT   CONVERT(VARCHAR(50), [Field])
                               FROM     [shop].[dbo].[tbl_stockid]
                               WHERE    stockid = 2
                             )
      --SET @number= CONVERT(VARCHAR(50), 100)
      SET @number= 200
      SET @productNo=''''+@productNo+''''
      SET @pingjie=''+@filed+''+'='+''+@number+''
      SET @sqlstring='UPDATE  tbl_product_store SET  '+@pingjie+' where product_No='+@productNo+' and product_size='+@size+' and color='+@color+''

转载于:https://www.cnblogs.com/ayuer/archive/2013/02/27/2935542.html