ALTER proc P_存过名字
@TiaoJian nvarchar(50), @AgentId int
as
select * from es_Agents
where BelongsAgentOrgID=@AgentId and (
AgentsName like '%'+@TiaoJian+'%'
or CellPhone like '%'+@TiaoJian+'%' )
注意点: 1. 模糊查询拼接参数 ,2 一个and 匹配多尔or 需要把 or 括起来
ALTER proc P_存过名字
@TiaoJian nvarchar(50), @AgentId int
as
select * from es_Agents
where BelongsAgentOrgID=@AgentId and (
AgentsName like '%'+@TiaoJian+'%'
or CellPhone like '%'+@TiaoJian+'%' )
注意点: 1. 模糊查询拼接参数 ,2 一个and 匹配多尔or 需要把 or 括起来
转载于:https://www.cnblogs.com/liuzheng0612/p/10870939.html