兄弟们，我有一个查询现在要移植到存储过程当中，代码为：
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锅