none
消息 106,级别 15,状态 1,第 1 行 查询中的表名太多。最多允许有 256 个 RRS feed

  • 问题

  • SELECT
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别',
    (SELECT SubName FROM DicSub WHERE DicName='性别' AND SubId=Sex) as '性别'
     FROM [Population]

     

    如何解决?

    2011年10月22日 3:33

答案

  • 规则使然: SQL Server中视图或者子查询最多支持256个。

    解决办法:
    SQL Server T-SQL批处理完全支持union256个以上的表,而且存储过程也支持引用超过256个以上的表.
    于是将原先创建视图的语句由create view 改为 create procedure,存储过程不带任何参数;
    原先调select * from 视图/表的地方SQL语句改为exec存储过程。

     存在的问题:大量使用上述方法,可能造成性能的降低。 

     

    建议LZ考虑使用其他方法来进行处理。



    [来者]——OCGP
    参考http://msdn.microsoft.com/zh-cn/library/ms177634.aspx
    [来者]——OCGP
    2011年10月22日 11:28

全部回复

  • 谁能帮忙解决一下,插叙表过多,WHY????????
    2011年10月22日 3:55
  • 真是牛人啦。。。写这么多表相同的东西有什么用处????


    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com
    2011年10月22日 6:04
  • 规则使然: SQL Server中视图或者子查询最多支持256个。

    解决办法:
    SQL Server T-SQL批处理完全支持union256个以上的表,而且存储过程也支持引用超过256个以上的表.
    于是将原先创建视图的语句由create view 改为 create procedure,存储过程不带任何参数;
    原先调select * from 视图/表的地方SQL语句改为exec存储过程。

     存在的问题:大量使用上述方法,可能造成性能的降低。 

     

    建议LZ考虑使用其他方法来进行处理。



    [来者]——OCGP
    2011年10月22日 11:25
  • 规则使然: SQL Server中视图或者子查询最多支持256个。

    解决办法:
    SQL Server T-SQL批处理完全支持union256个以上的表,而且存储过程也支持引用超过256个以上的表.
    于是将原先创建视图的语句由create view 改为 create procedure,存储过程不带任何参数;
    原先调select * from 视图/表的地方SQL语句改为exec存储过程。

     存在的问题:大量使用上述方法,可能造成性能的降低。 

     

    建议LZ考虑使用其他方法来进行处理。



    [来者]——OCGP
    参考http://msdn.microsoft.com/zh-cn/library/ms177634.aspx
    [来者]——OCGP
    2011年10月22日 11:28
  • Hello, 虽然没有讲明为什么数据只是支持256个视图或表。可不探究为什么,由于我要导入到Execl文件中,也是相同数字 噩梦数字"256",最终不得不考虑,讲19张表,325列分成多个T-SQL来执行。每条SQL为Execl中的Sheel...感谢您的指导。之前,我也考虑用视图,加上索引。但我也无法保证这样会肯定没事,因为,以后会涉及到动态添加字段和表。类似于OA自动化处理数据库中的操作一般。

    再次感谢。 Thanks......

    2011年10月22日 17:04