Fejl i SP søgning
Nedenstående har syntaxen i orden, men returnere konsekvent ingenting..Har jeg alligevel syntaxen forkert.
CREATE PROCEDURE usp_simpleSearch
@phrase nvarChar(1000)
AS
SELECT Headline, HeadlineOnPage, Content, ContentId
FROM tbl_content as c
WHERE (c.Headline Like '%@phrase%'
Or c.HeadlineOnPage Like '%@phrase%'
Or c.Content Like '%@phrase%')
GO
