34,587
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE [dbo].[GET_MessagesManager_Messages]
@nameString varchar(30)
AS
BEGIN
select *
from tb
where isnull(name,'') like '%'+isnull(@nameString,'')+'%'
END
where (charindex(@nameString,name) > 0 and @nameString <> '') or (1=1 and @nameString = '')