有一个表,如下:
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