存储过程中like的问题
eduyp 2006-03-29 05:02:13 CREATE PROCEDURE GetBoardIDByParentPathlike
@TableName nvarchar(50),
@ParentPath nvarchar(50)
AS
SET NOCOUNT ON
DECLARE @STR nvarchar(50)
SELECT @STR = LTRIM(RTRIM(@ParentPath))
EXEC ('SELECT BoardID FROM '+@TableName+' WHERE ParentPath like '+@STR+'')
RETURN 0
GO
--运行后
EXEC GetBoardIDByParentPathlike
shop_TreeBoard,
'0,1,7'
----------------
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: ',' 附近有语法错误。