select * from tb
where bookid=Isnull(@bookid,bookid)
and (@bookname is null or bookname like '%'+@bookname+'%')
and (@booktype is null or booktype like '%'+@booktype+'%')
and (@author is null or author like '%'+@author+'%')
and (@publisher is null or publisher like '%'+@publisher+'%')
and isbn=Isnull(@isbn,isbn)

declare @sql nvarchar(max)
set @sql = ' select * from tb where 1=1 '
if(@bookid is not null)
    @sql = @sql + ' and bookid='+@bookid
if(@bookname is not null)
    @sql = @sql + ' and bookname like ''%'+@bookid+'%'' '
if...
...

exec(@sql)

Create Procedure QueryBook
 @bookid nvarchar(20),
 @bookname nvarchar(20),
 @booktype nvarchar(20),
 @author nvarchar(20),
 @publisher nvarchar(20),
 @isbn nvarchar(20)
as
Declare @QueryString nvarchar(1000)
Set @QueryString=''

if IsNull(@bookid,'')<>''
Set @QueryString=@QueryString+' bookid=''' +@bookid+''''

if IsNull(@bookname,'')<>''
Set @QueryString=@QueryString+ when case @QueryString='' then '' else ' And ' end +' bookname Like ''%' +@bookname+'%'''

if IsNull(@booktype,'')<>''
Set @QueryString=@QueryString+ when case @QueryString='' then '' else ' And ' end +' booktype Like ''%' +@booktype+'%'''

if IsNull(@author,'')<>''
Set @QueryString=@QueryString+ when case @QueryString='' then '' else ' And ' end +' author Like ''%' +@author+'%'''

if IsNull(@publisher,'')<>''
Set @QueryString=@QueryString+ when case @QueryString='' then '' else ' And ' end +' publisher Like ''%' +@publisher+'%'''

if IsNull(@isbn,'')<>''
Set @QueryString=@QueryString+' isbn=''' +@isbn+''''


Set @QueryString='select * from book where ' + @QueryString
-- 返回查询结果
exec (@QueryString)
go

CREATE PROC Book
(
 @bookid nvarchar(20),
 @bookname nvarchar(20),
 @booktype nvarchar(20),
 @author nvarchar(20),
 @publisher nvarchar(20),
 @isbn nvarchar(20)

)
AS
 SET NOCOUNT ON
  
  DECLARE @sql nvarchar(4000)
SET @sql='SELECT * FROM tbname WHERE 1=1'
    +CASE WHEN @bookid IS NULL THEN '' ELSE ' AND bookid=@bookid' END
    +CASE WHEN @bookname IS NULL THEN '' ELSE ' AND bookname=@bookname' END
    +CASE WHEN @booktype IS NULL THEN '' ELSE ' AND booktype=@booktype' END
    +CASE WHEN @author IS NULL THEN '' ELSE ' AND author=@author' END
    +CASE WHEN @publisher IS NULL THEN '' ELSE ' AND publisher=@publisher' END
    +CASE WHEN @isbn IS NULL THEN '' ELSE ' AND isbn=@isbn' END
EXEC sp_executesql @sql,N'
    @bookid nvarchar(20),
        @bookname nvarchar(20),
        @booktype nvarchar(20),
        @author nvarchar(20),
        @publisher nvarchar(20),
        @isbn nvarchar(20)
',@bookid,@bookname,@booktype,@author,@publisher,@isbn
GO

CREATE PROC Book
(
 @bookid nvarchar(20),
 @bookname nvarchar(20),
 @booktype nvarchar(20),
 @author nvarchar(20),
 @publisher nvarchar(20),
 @isbn nvarchar(20)

)
AS
 SET NOCOUNT ON
  
  DECLARE @sql nvarchar(4000)
SET @sql='SELECT * FROM tbname WHERE 1=1'
    +CASE WHEN @bookid IS NULL THEN '' ELSE ' AND bookid=@bookid' END
    +CASE WHEN @bookname IS NULL THEN '' ELSE ' AND bookname like ''%'+@bookname+'%''' END
    +CASE WHEN @booktype IS NULL THEN '' ELSE ' AND booktype like ''%'+@booktype+'%''' END
    +CASE WHEN @author IS NULL THEN '' ELSE ' AND author like ''%'+@author+'%''' END
    +CASE WHEN @publisher IS NULL THEN '' ELSE ' AND publisher like '%''+@publisher+'%''' END
    +CASE WHEN @isbn IS NULL THEN '' ELSE ' AND isbn like '%''+@isbn+'%''' END
EXEC sp_executesql @sql,N'
    @bookid nvarchar(20),
        @bookname nvarchar(20),
        @booktype nvarchar(20),
        @author nvarchar(20),
        @publisher nvarchar(20),
        @isbn nvarchar(20)
',@bookid,@bookname,@booktype,@author,@publisher,@isbn
GO