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/