USP_SEARCHLIST_MARKETINGSURVEYQUESTION

Search for marketing survey questions.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN	Question
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



            CREATE procedure dbo.USP_SEARCHLIST_MARKETINGSURVEYQUESTION
            (
                @NAME nvarchar(100) = null,
                @MAXROWS smallint = 500
            )
            as
                set @NAME = COALESCE(@NAME,'') + '%' ;

                select top(@MAXROWS)
                    ID,
                    QUESTIONTEXT
                from 
                    dbo.MARKETINGSURVEYQUESTION
                where
                     (QUESTIONTEXT LIKE @NAME)
                order by 
                    QUESTIONTEXT asc