存储过程模糊查询(like)

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_TestLike]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_TestLike]
go
--直接执行like
--@news_title ,输入参数,默认为null
create procedure up_TestLike
@news_title varchar(100) = null
as
   select top 10 * from news where news_title like '%' +@news_title+ '%'

go

exec up_TestLike

----------------------------------------------------------------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_TestLikeStr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_TestLikeStr]
go
--组合字符号串执行like
--@news_title ,输入参数,默认为title
create procedure up_TestLikeStr

@news_title varchar(100) = 'title'

as
   declare @sql varchar(8000)

   set @sql= 'Select top 10  * From news Where news_title like ''%'+@news_title+'%'''
   --set @strSql=@strSql+' where khbh like ''%'+@custNo+'%'''
   --select * from IndividualSaleHouse where user_ID=@user_ID and Area_ID=@Area_ID and HouseName like '%'+@HouseName+'%' order by IndividualSaleHouse_ID  desc
   exec (@sql)
go

exec up_TestLikeStr 'title1'
---------------------------
上面从查询分析器拷贝来的,两种方式查询like
详细测试了.....MARK......

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16436858/viewspace-609113/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16436858/viewspace-609113/