想请问一下模糊查询的sp怎么写？

[Lansie]

比如
@name是变量，字段name需要模糊匹配
select * from person where name like
后面怎么写呢？
谢了

[zhengqinxu]

declare @name char(10)
set @name='123'
print('select * from person where name like ''%'+ltrim(rtrim(@name))+'%'')
先把得到的语句print出来

[marco08]

@AppName char(20)=null,


改為

@AppName varchar(20)=null,

[Lansie]

@AppName char(20)=null,


改為

@AppName varchar(20)=null,


正解，谢谢各位了

[akuzou]

select * from person where name like '%'+@name+'%'

[jacobsan]

exec('select * from person where name like ''%'+@name+'%''')

[marco08]

select * from person where name like '%'+@name+'%'

[Lansie]

我也是这么写的，可死活没结果出来啊，郁闷，不知道哪里出错了

[zty0527]

declare @str nvarchar(40)
set @str='zh'
select * from a where fmemo like '%'+@str+'%'

[九斤半]

CREATE PROC PS_TEST
@NAME NVARCHAR(20)
AS
BEGIN
SET NOCOUNT ON

SELECT * FROM person WHERE [name] LIKE '%'+@NAME+'%'

SET NOCOUNT OFF
END
GO

EXEC PS_TEST '义'

DROP PROC PS_TEST

[akuzou]

我也是这么写的，可死活没结果出来啊，郁闷，不知道哪里出错了
---------
把你的贴出来！

[rookie_one]

select * from person where name like '%['+@name+']%'

[Lansie]

PROC [dbo].[sp1_AppConfig]
@AppName char(20)=null,
@ServerName varchar(20)=NULL,
SELECT * FROM AppConfig WHERE AppName like '%'+@AppName+'%' and Server=IsNull(@ServerName,ServerName)

EXEC @return_value = [dbo].[sp1_AppConfig]
@AppName = N'pav',
@PMServer = NULL,

表中有许多‘pav’的记录的，可就是一条不出来，帮我看看怎么回事

[akuzou]

Server=IsNull ??
--------
IsNull是字段吗？
或者你想Server is null
或者 Server = 'IsNull'

[akuzou]

不好意思，看错了！

[akuzou]

@AppName 改成rtrim(@AppName) 试试