一个关于拼接字符串的模糊查询,请高手帮忙查错。
lxhvc 2005-03-15 09:37:10 ALTER PROCEDURE dbo.SP_SearchEngine
@keyWord varchar(20), --检索关键词
@foodType int , --检索类型,1为饮食消费类,2为娱乐消费类
@areaID int, --检索地域类别
@bizType int , --详细分类2,根据表中定义
@baseConsume varchar(20) --基本消费价位
AS
declare @sqlstr varchar(8000)
declare @dou varchar(3)
set @dou = [']
set @sqlstr = 'select vc_BizerName ,vc_Addr,vc_Tel,vc_Principal,vc_BaseConsume from TBL_Bizer where'
if @keyWord <> ''
set @sqlstr = @sqlstr + 'vc_BizerName like'+@dou+'%'+ @keyWord +'% or vc_Addr like %'+ @keyWord + '%'
else
set @sqlstr = @sqlstr + 'vc_BizerName like _ or vc_Addr like _'
if @areaID <> -1
set @sqlstr = @sqlstr +' and i_areaID='+@areaID
if @bizType <> -1
set @sqlstr = @sqlstr + ' and i_BizTypeID='+@bizType
if @baseConsume <> ''
set @sqlstr = @sqlstr + ' and vc_BaseConsume =' +@baseConsume
EXEC(@sqlstr)