动态选择列（SQL存储过程）

我创建一个过程，将更新一个动态选择列在单独一行，并有强烈的理由是这个NEEED的

我是新手，会APPRICIATE明确的帮助

波塞尔:
我如何赋值@ InpArgXEl列，变量@ ColumnID，，PatternDtab（数据库表）表示主键列PattnRowID

ALTER PROCEDURE dbo.TransPayPattn	

(

 @InpArgXEl XML OUTPUT,

 @ColumnID NCHAR(10),

 @RowNo INT OUTPUT

)

 

SET @ColumnID = '['+@Column+']'

 

--Litrarilly

UPDATE PatternDtab SET @ColumnID = @InpArgXEl WHERE PattnRowID=@RowNo

 

--what is the RIGHT way to do this?

DECLARE @Cmd  VARCHAR(MAX)

 

SET @Cmd= N'UPDATE PatternDtab SET '+@ColumnID+' = @InpArgXEl WHERE PattnRowID=@RowNo'

 

EXECUTE sp_executesql @Cmd

 

-- Confirmation

SET @InpArgXEl = (SELECT ... -- I ALSO NEED TO RE-EVALUATE THE CURRENT VALUE OF @ColumnID