CREATE PROCEDURE SearchList1 (
@FirValue int,
@SecValue varchar(100)
)
as DECLARE @i INT
DECLARE @C varchar
DECLARE @B varchar
SET @i=1
WHILE @i<=LEN(@SecValue)
BEGIN
set @B=substring(@Secvalue,@i,1)
set @C=@C+' or SKindName like ''%'+@B+'%'
SET @i=@i+1
END
exec('select * from FlashList as a inner join FSmallKind
as b on a.FKind=b.id where b.Kid ='+@FirValue+' and
FName like ''%'+@SecValue+'%' +@C+ ''' order by FDateTime desc')
GO
===================
这个 @C总是 null
为什么呢?
@FirValue int,
@SecValue varchar(100)
)
as DECLARE @i INT
DECLARE @C varchar
DECLARE @B varchar
SET @i=1
WHILE @i<=LEN(@SecValue)
BEGIN
set @B=substring(@Secvalue,@i,1)
set @C=@C+' or SKindName like ''%'+@B+'%'
SET @i=@i+1
END
exec('select * from FlashList as a inner join FSmallKind
as b on a.FKind=b.id where b.Kid ='+@FirValue+' and
FName like ''%'+@SecValue+'%' +@C+ ''' order by FDateTime desc')
GO
===================
这个 @C总是 null
为什么呢?
解决方案 »
- Server Error in '/' Application.
- girdview导出excel问题
- formview 插入数据后清空文本框
- asp.net中过长数据插入数据库报错,大家怎么处理?
- 一个郁闷了我一天的问题
- 赶集网网页采集功能!
- 用分层方式做项目,几个解决方案中应该建哪几个项目,每个项目都是做什么的
- 使用freetextbox 1.6.3,我修改了源代码,请问如何编译成DLL以使用?
- 请listhome、 xiaohutushen、WUNEN进来接分
- 模板列的问题
- 5MB以上文件上传各位有什么好的解决办法?
- 网站改版了但在baidu,goolge搜索到的页面还是旧的,已经失效的页面链接,这个怎么办啊?
DECLARE @B varchar(100)
SET @C = ''
SET @B = ''