存储过程 怎么动态选择更新列

create PROCEDURE [dbo].[sp_ProductSetProduct]--------------------------------------目的：设置产品。------------------------------------@Id int,[email protected]@Action nvarchar(50),@SetValue intAS--本来只能固定更新IsCommend这个字段UPDATE ProductSET IsCommend = @SetValueWHERE Id = @Id[email protected]，想有选择的更新一个字段UPDATE Product--这样好象不行IF @Action = 'commend' BEGINSET IsCommend = @SetValueENDWHERE Id = @Id

create PROCEDURE [dbo].[sp_ProductSetProduct]--------------------------------------目的：设置产品。------------------------------------@Id int,[email protected]@Action nvarchar(50),@SetValue intASBEGIN    SET NOCOUNT ON     IF @Action = 'commend'     BEGIN        UPDATE Product SET 字段=值 WHERE [email protected]    END    IF @Action = 'new'     BEGIN        UPDATE Product SET 字段=值 WHERE [email protected]    END    ELSE    BEGIN        UPDATE Product SET 字段=值 WHERE [email protected]    ENDEND