加一个collate Chinese_PRC_CI_AS

SELECT
        so.name table_name,
        sep.value table_comment,
        so.create_date create_time,
        so.modify_date update_time
        FROM
        sys.objects AS so
        LEFT JOIN sys.extended_properties AS sep ON so.object_id = sep.major_id
        WHERE
        so.type = 'U'
        AND sep.minor_id = 0
        AND so.name NOT LIKE 'qrtz_%' AND so.name NOT LIKE 'gen_%'
        AND so.name collate Chinese_PRC_CI_AS NOT IN (select table_name from gen_table)

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

Captcha Code