SQLͬһÌõ¼þ¶à×ֶβéѯ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÒ»¸ö±í£¬ÈçÏ£º
create table #tmp(id int,cusno varchar(10),cusname nvarchar(50))

insert into #tmp(id,cusno,cusname)
select 1, 'C10001', 'ÁªÏëµçÄÔ' union all
select 2, 'C10002', '»ÝÆÕµçÄÔ' union all
select 3, 'C10003', '¹È¸è¹«Ë¾'

drop table #tmp

ÈçºÎʵÏÖ£¬¿É¸ù¾Ýcusno²éѯµÃµ½cusname½á¹û£¬»òÕ߸ù¾Ýcusname²éѯµÃµ½cusname½á¹û£º
select cusname from #tmp where cusno like '%C%'
select cusname from #tmp where cusname like '%µçÄÔ%'

create procedure sp_test
@str nvarchar(20)
as
--select cusname from #tmp where cusno like '%+@str+%'

´æ´¢¹ý³ÌÈçºÎʵÏÖ£¬¶àл£¡

---

SQL code:
select cusname from #tmp where cusno like '%C% or cusname like '%µçÄÔ%'

---

SQL code:
select cusname from #tmp where cusno like '%C%' or cusname like '%µçÄÔ%'

---

SQL code:

create procedure sp_test
@str nvarchar(20)
as

select cusname from #tmp where cusno like '%'+@str+'%' or cusname like '%'+@str+'%'

---

create procedure sp_test
@str nvarchar(20)
as
begin
  select cusname from #tmp where charindex(@str,cusno) > 0