南京SEO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

ALTER   PROC dbo.P_IsFilter
 @sMessage VARCHAR(8000)
AS
DECLARE
 @iResult INT

 set nocount on
 
 set @iResult=0
 

 if (EXISTS(select * from T_Filter where charindex(Keyword,@sMessage) > 0))
 begin
  set @iResult=1
  goto exit_proc
 end

exit_proc:
 set nocount off
 return @iResult
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO