达梦数据库常用SQL之生成启用带自增列表插入功能及insert插入语句

SELECT
        ' SET IDENTITY_INSERT "'
        ||B.NAME
        ||'" ON; INSERT INTO "'
        ||B.NAME
        ||'"("'
        ||LISTAGG(A.NAME, '","') WITHIN GROUP (
ORDER BY
        A.COLID)
        ||'") SELECT * FROM "'
        ||B.NAME
        ||'";'
FROM
        SYSCOLUMNS A
INNER JOIN SYSOBJECTS B
ON
        A.ID=B.ID
WHERE
        B.NAME IN
        (
                SELECT DISTINCT
                        S.NAME
                FROM
                        SYSOBJECTS S,
                        SYSCOLUMNS C
                WHERE
                        S.ID    =C.ID
                    AND C.INFO2 =1
                    AND S.NAME IN
                        (
                                SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME NOT LIKE 'CTI%'
                        )
        )
    AND B.SCHID=
        (
                SELECT ID FROM SYSOBJECTS WHERE TYPE$='SCH' AND NAME='SYSDBA'
        )
GROUP BY
        B.NAME;