I have search results from a SQL query using three parameters @keyword, @groupData, @actionData. I want to display the results in a string "Your search for KEYWORD and GROUP and ACTION have returned the following:"
How do I set up my stored procedure to pass these? something like this? do I even need a stored procedure
CREATE PROCEDURE sp_ReturnKeywordGroupsAction
(
@keyword varchar(100),
@groupData varchar(100),
@actionData varchar(100),
)
AS
--check keyword
IF (@keyword <> '')
--check group
IF (@groupData <> '')
--check action
IF (@actionData <> '')
GO
--------------------------------
From: Grant Boettcher
-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)
<Id>NDUEDk977EqZAPAuLgid9g==</Id>