简单的单引号问题？动态SQL

[vfp_system]

下面的语句怎么才能执行成功？

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

[wzy_love_sly]

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

[Limpire]

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

[hackztx]

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

[dawugui]

[Quote=引用楼主 vfp_system 的帖子:]
下面的语句怎么才能执行成功？

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

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