儲存過程模糊查詢(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