存储过程中的多条件查询语句怎么写
1个回答
展开全部
存储过程中的多条件查询语句怎么写
create proc dbo.Usp_GetInfo
(
@infoTitle as varchar(50)='',
@InfoBody as varchar(50)=''
)
as
begin
select
InfoTitle,InfoBody,tel,PubDate,linkMan,KindName
from
Info
inner join InfoKinds on Info.InfoKindid=InfoKinds.InfoKindid
where
InfoTitle like '%'+@InfoTitle+'%'
and InfoBody like '%'+@InfoBody+'%'
end
create proc dbo.Usp_GetInfo
(
@infoTitle as varchar(50)='',
@InfoBody as varchar(50)=''
)
as
begin
select
InfoTitle,InfoBody,tel,PubDate,linkMan,KindName
from
Info
inner join InfoKinds on Info.InfoKindid=InfoKinds.InfoKindid
where
InfoTitle like '%'+@InfoTitle+'%'
and InfoBody like '%'+@InfoBody+'%'
end
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
