BorlandTalk.com

John Smith · Guest

I have a stored procedure which have two parameters: @columnname and
@id,I want to get specified column's record value by @columnname
parameter and id equals to the @id parameter.but I don't know how to
write that sp.it should looks like:

CREATE PROCEDURE dbo.StoreProcedure
@ColumnName varchar(255),
@ID varchar(255),
@Value varchar(255) OUTPUT
AS

SELECT @Value = @ColumnName FROM MyTable WHERE ID = @ID

RETURN

but the code is not correct.how to do that?thanks

Maurice Telkamp · Guest

You will have to build a SQL-string in your stored procedure, and execute it
using sp_executeSQL

for example

DECLARE @sql varchar(1000)

SET @sql='SELECT ' + @ColumnName + ' FROM myTable WHERE .....etc

EXEC sp_ExecuteSQL @sql

"John Smith" <thecoder (AT) 163 (DOT) com> wrote