22,209
社区成员
发帖
与我相关
我的任务
分享
Create PROCEDURE test
@SubType varchar(50), @SearchWord varchar(50)
AS
BEGIN
set @SearchWord=nullif(@SearchWord,'')
select * from bookinfo where SubType=@SubType AND SearchWord=isnull(@SearchWord, SearchWord)
END
GO
SELECT *
FROM BookInfo
WHERE IsShow = 'Y'
AND ( ( ( @KFName = ''
OR @KFName IS NULL
)
AND KFName IN ( SELECT KFName
FROM KFTABLE
WHERE UserList LIKE '%' + @Name + '%' )
)
OR KFName = @KFName
)
AND ( CASE WHEN @SubType = 'A' THEN Qty
ELSE 1
END ) > 0
AND ( CASE WHEN @SubType = 'B' THEN Qty
ELSE -1
END ) < 0
AND ( ( @SearchWord = ''
OR @SearchWord IS NULL
)
OR ( [Desc] LIKE '%' + @SearchWord + '%'
OR PWNO LIKE '%' + @SearchWord + '%'
)
)
SELECT *
FROM bookinfo
WHERE SubType = @SubType
AND ( CASE WHEN searchword = A THEN @searchword
WHEN searchword = B THEN @searchword22
ELSE @searchword22
END ) = SearchWord
select * from bookinfo where (case when @SubType is not null then @SubType else null end)=SubType
Create PROCEDURE test
@SubType varchar(50), @SearchWord varchar(50)
AS
BEGIN
IF (@SearchWord IS NULL)
SELECT * from bookinfo where SubType=@SubType
ELSE
SELECT * from bookinfo where SubType=@SubType AND SearchWord=@SearchWord
END
GO
SELECT *
FROM bookinfo
WHERE SubType = @SubType
AND ( @SearchWord IS NULL
OR SearchWord = @SearchWord
);