Advanced Stored procedure...

May 25 2004 9:47 AM
Hello, (Excuse my english, i'm a french man) I want to make a stored procedure on that model : CREATE Procedure SGCP_GetEleveArgs ( @Arg1 nVarChar, @Val1 nVarChar ) AS SELECT * FROM Eleve WHERE @Arg1 = @Val1 So you understand that i want to pass my argument (@Arg1) as a field of a column. but it gives : WHERE 'Nom' = 'Dupont' but i want to have : WHERE Nom = Dupont for it to work. Have you an idea to solve that problem ? Thanx

Answers (7)