troubleshooting Question

Create a stored procedure that can update any column

Avatar of Russ Suter
Russ Suter asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
3 Comments1 Solution52 ViewsLast Modified:
Here's a simple stored procedure:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros