I have an winform that speaks to the MS SQL database. My user needs to be able to search for posts in customer table(kunde)
He has to be able to search for firstname, last name and e-mail. I want to make it so that the user does not have to specify what to search for and then type in the keyword. I was thinking to make it as an stored procedyre that looks like this:
CREATE PROCEDURE dbo.finnKunde
@fornavn varchar
@etternavn varchar
@epost varchar
AS
SELECT KundeID, Fornavn, Etternavn, Adresse, Postnummer, Poststed, Telefon, Epost
FROM Kunde
WHERE (Fornavn Like '%' + @fornavn + '%') OR
(Etternavn Like '%' + @etternavn + '%') OR
(Epost Like '%' + @epost + '%')
Fornavn is "first name", etternavn is "last name" and epost is "email".
But this genreates an error that says: "incorrect syntax near '@etternavn'. Must declare scalar variable "@fornavn".
But As far as I can see it variable is declared for @fornavn.
Can it be that Stored procedyre can not take more then 1 search field
Stored procedure in C#
james_cline_
Are you using Sql Server 2000 I think it should be:
CREATE PROCEDURE dbo.finnKunde
( '<-- Opening bracket
@fornavn varchar, '<-- Comma separated
@etternavn varchar,
@epost varchar
)
AS
SELECT KundeID, Fornavn, Etternavn, Adresse, Postnummer, Poststed, Telefon, Epost
FROM Kunde
WHERE (Fornavn Like '%' + @fornavn + '%') OR
(Etternavn Like '%' + @etternavn + '%') OR
(Epost Like '%' + @epost + '%')
AlexCr
Hei.
I was using SQL server Exress 2005
You were right, I need comma . Now it works beatufully.
Thank you