求救存储过程拼接问题
兄弟们，我有一个查询现在要移植到存储过程当中，代码为：
ALTER PROCEDURE [dbo].[test]
@myWord nvarchar
AS
DECLARE @tellMe VARCHAR(8000)
BEGIN
-- routine body goes here, e.g.
-- SELECT 'Navicat for SQL Server'
set @tellMe='SELECT top 5 * from news WHERE content LIKE('%'+@myword+'%')';
EXEC(@tellMe);
END
但始终报错：
数据类型varchar在modulo运算符中不兼容。
哪位朋友能帮我？

[解决办法]
ALTER PROCEDURE [dbo].[test]
@myWord nvarchar (4000)
AS
DECLARE @tellMe VARCHAR(8000)
BEGIN
-- routine body goes here, e.g.
-- SELECT 'Navicat for SQL Server'
set @tellMe='SELECT top 5 * from news WHERE content LIKE(''%'+@myword+'%'')';
EXEC(@tellMe);
END

[解决办法]

SQL code

ALTER PROCEDURE [dbo].[test] @myWord NVARCHAR AS      DECLARE @tellMe VARCHAR(8000)     BEGIN   -- routine body goes here, e.g.   -- SELECT 'Navicat for SQL Server'         SET @tellMe = 'SELECT top 5 * from news WHERE content LIKE(''%''+@myword+''%'')' ;             --PRINT @tellMe         EXEC(@tellMe) ;     END
[解决办法]
up7锅