SQLSERVER中遇到的SQL问题

with tmp(menuid,parentid,menuname,path)as(
select menuid,menuname  path  from TKWORK.dbo.p_menu where menuid='A1'
UNION ALL
SELECT CHILD.menuid,CHILD.PARENTID,CHILD.MENUNAME,PARENT.path +'-'+child.menuname FROM TKWORK.dbo.P_MENU CHILD,TMP PARENT
WHERE CHILD.PARENTID=PARENT.menuid)
SELECT * FROM TMP

报错信息如下：

[Err] 42000 - [SQL Server]Types don't match between the anchor and the recursive part in column "path" of recursive query "tmp".

报错原因是字段的类型、长度必须一样，所以做如下修改：

with tmp(menuid,cast(menuname as varchar(50)) path  from TKWORK.dbo.p_menu where menuid='A1'
UNION ALL
SELECT CHILD.menuid,cast(PARENT.path as varchar(250))+'-'+cast(child.menuname as varchar(249)) FROM TKWORK.dbo.P_MENU CHILD,TMP PARENT
WHERE CHILD.PARENTID=PARENT.menuid)
SELECT * FROM TMP

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!