存储过程遇到的问题

[ding0623]

在存储过程中将"where ..."条件判断作为参数@Filter

执行时如果@Filter是where name like '%王%'这种形式时该怎么写? 查了好多都没效果..

[dawugui]

where charindex(@filter,name) > 0

[快溜]

declare @Filter varchar(50),@str varchar(1000)
set @Filter='where name like ''%王%'''
set @str='select * from tb '+@Filter
exec(@str)

[ding0623]

exec [dbo].[a] 'where name like ''%王%'''

好像这种形式就不行?

[AcHerat]

set nocount on
create table tb(id int,num numeric(18,8),ar varchar(10))
insert into tb select 1,12.12000000,'a'
insert into tb select 3,125.13500000,'a'
insert into tb select 4,4821.00000000,'baa'
insert into tb select 5,1245.78950000,'vav'
insert into tb select 6,120.14579210,'d'
insert into tb select 7,15478.00000000,'d'
insert into tb select 8,334200.00000000,'d'
go

create proc result(@wh varchar(100))
as
exec('select * from tb ' + @wh)
go

exec result 'where ar like ''%a%'''

drop proc result
drop table tb
set nocount off


/*
id          num                                     ar
----------- --------------------------------------- ----------
1           12.12000000                             a
3           125.13500000                            a
4           4821.00000000                           baa
5           1245.78950000                           vav

[--小F--]

'where name like ''%王%'''

[--小F--]

多转义一下就OK了

[gw6328]

[Quote=引用 6 楼 fredrickhu 的回复:]
多转义一下就OK了
[/Quote]
+1