נושא: עזרה בSP עבור SQL SERVER

    and (@bookName  is null or bookName like replace(@bookName,@bookName, '%' +@bookName + '%')
        

WITH Ordered AS
(
    SELECT ROW_NUMBER() OVER (ORDER BY ordered desc, bookName asc, bookID asc) AS RowNumber, bookId, bookName, memo, Price,pictureUrl, author
    FROM    adminUser.qBooks
    WHERE    deleted =0
            and show = 1
            and (@subCategorID is null or subcategoryID=@subCategorID)
            and (@bookName  is null or bookName like replace(@bookName,@bookName, '%' +@bookName + '%')
            and (@author  is null or author like @author)
            and (@publisher  is null or publisher like @publisher)
            and (@fromPrice  is null or price >= @fromPrice)
            and (@toPrice  is null or price <= @toPrice)

)
SELECT    @totalCount = COUNT(*)
FROM    Ordered;

SELECT    bookId,
        bookName,
        memo,
        Price,
        pictureUrl,
        author
FROM    Ordered
WHERE    RowNumber between @startIndex and @endIndex