为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】:sqlserver以下语法修改为达梦语法怎么修改
CREATE FUNCTION getParentCateViewer(@id INT) RETURNS TABLE AS RETURN (
WITH cte AS (
SELECT *
FROM KTS_FILE_CATEGORY
WHERE ID = @id
UNION ALL
SELECT t.
FROM KTS_FILE_CATEGORY AS t
INNER JOIN cte AS c ON t.ID = c.PARENT_ID
)
SELECT OPERCODE FROM HD_FORM_GROUP_MEMBER WHERE FORMID = 'model:G_1_ktsFileCategory' AND FIELD = 'readers' AND BEANID = (
SELECT TOP 1 ID
FROM cte
WHERE ID != @id
AND ( SELECT COUNT ( * ) FROM HD_FORM_GROUP_MEMBER g WHERE g.FORMID = 'model:G_1_ktsFileCategory' AND g.BEANID = cte.ID AND g.FIELD = 'readers' ) > 0
)
)
把函数中涉及到的表DDL整个TXT发下呗