CREATE PROCEDURE P_Test_Num1
@KeyWord NVARCHAR(100)
AS
DECLARE @SQL NVARCHAR(200)
SET @KeyWord=REPLACE(@KeyWord,'''','''''')
SET @SQL='SELECT COUNT(*) AS Total FROM TabName WHERE Colomn1 Like ''%'+@KeyWord+'%'''
--EXECUTE (@SQL)
PRINT @SQL

EXECUTE P_Test_Num1 abc
--OUTPUT:SELECT COUNT(*) AS Total FROM TabName WHERE Colomn1 Like '%abc%'
--DROP PROCEDURE P_Test_Num1

declare @s varchar(200) 
set @s='select count(*) as Total from [b_newsClass] where newsClassName like ''%健%''' 
exec @s