存储过程中的like怎么写？

[真心若骄阳]

存储过程中
WHERE ( [title] like @title_1)
和 WHERE ( [title] like '%@title_1%')
这两个都不对啊

[OracleRoob]

WHERE ( [title] like '%' + @title_1 + '%')

[gahade]

declare @a varchar(10)
set @a = '中'
select * from table
where col like @a+'%'

这样可以啊

[gahade]

楼主的第一句也会报语法错误吗?

[paoluo]

Create Table TEST(ID Int,Name Varchar(10))
Insert TEST Select 1,'aa'
Union All Select 2,'bb'
Union All Select 3,'cc'
GO
Declare @name Varchar(1000)
Set @name='a'
EXEC('Select * From TEST Where Name Like ''%'+@name+'%''')
GO
Drop Table TEST
GO
--Result
/*
ID Name
1 aa
*/

[ping3000]

create table test(name nvarchar(20))
insert into test(name)
select '张三' union all
select '王二'
go

create proc p
@name nvarchar(20)

as
select * from test where name like '%' + @name + '%'
go

exec p '二'

drop table test
drop proc p