USP_SEARCHLIST_EVENTAUCTION

Search for and view auction records.

Parameters

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

Definition

Copy



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

                    select top(@MAXROWS)
                        EVENTAUCTION.ID,
                        EVENT.NAME
                    from 
                        dbo.EVENTAUCTION
                    inner join dbo.EVENT
                        on EVENT.ID = EVENTAUCTION.ID
                    where
                         (NAME LIKE @NAME + '%')
                    order by 
                        NAME asc