34,590
社区成员
发帖
与我相关
我的任务
分享
create procedure dbo.Test1
@nLogicFilter int,
@strName varchar(8000)
AS
BEGIN
select nID, strName from dbo.Test where (@nLogicFilter = 1 and strName like @strName) or (@nLogicFilter = 2 and strName = @strName)
END
select nID, strName from dbo.Test where strName like case @nLogicFilter when 1 then @strname else '%'+@strname+'%' end