parameter passing in Stored Procedure 1

[rajkum]

Hi,
I have a stored procedure where i pass two parameter
1. the field Name and
2. the Value

from an ASP page.

The Code below:

CREATE PROC storedProcName
@fldName varchar
@fldVal varchar
as
BEGIN
Select * FROM tableName WHERE @fldName = @fldVal
END

This does not return me any data....where it has to.
But when I replace the @fldName with the actual field name it works...
Pls Help..

Thanks in advance.
Raj.

 

[JayKusch]

Ah ... time for some dynamic SQL

declare @command varchar(400)

set @command = 'Select * FROM tableName WHERE' + @fldName + ' = ' + @fldVal

exec (@command)

Thanks

J. Kusch

 

[ClaytonQ]

Did you put in a comma after @fldName, like this?

CREATE PROC storedProcName
 @fldName varchar,
 @fldVal  varchar
as
BEGIN
Select * FROM tableName WHERE @fldName = @fldVal  
END

 

[JayKusch]

May need another space between the where and the ' as in ...

WHERE '

Also add a print statment, before your exec statment, to see how you code looks after the dynamic build. As in ...

PRINT @Command

Thanks

J. Kusch

 

[rajkum]

Thanks J. Kusch.
That was helpfull!!