asked on
CREATE PROCEDURE [foo]
(
@Id INT,
@Value VARCHAR(MAX)
)
AS
UPDATE
[dbo].[Element]
SET
[Element].[ColumnName] = @Value
WHERE
[Element].[Id] = @Id
It works just fine for its purpose. However, what do I do if I want ColumnName to be a passed variable? Something that would work more like this:CREATE PROCEDURE [foo]
(
@Id INT,
@Key VARCHAR(MAX),
@Value VARCHAR(MAX)
)
AS
UPDATE
[dbo].[Element]
SET
[Element].[@Key] = @Value
WHERE
[Element].[Id] = @Id
How do I accomplish that task?