仓位值集列表审核仓位时报错:错误编号: BOS_ExecuteNonQuery错误信息: 表“T_BAS_FLEXVALUESDETAIL”的 索引“IDX_BAS_FLEXVALUESDETAIL_U”在键列表中具有 80 个列。索引 键列列表的最大限制为 16。
Sql语句: IF NOT EXISTS (SELECT 1 FROM (SELECT SYSOBJECTS.NAME AS TABLE_NAME, SYSINDEXES.NAME AS INDEX_NAME FROM SYSOBJECTS INNER JOIN SYSINDEXES ON SYSINDEXES.ID = SYSOBJECTS.ID) AS KSQL_INDEXES WHERE INDEX_NAME = 'IDX_BAS_FLEXVALUESDETAIL_U')
BEGIN
CREATE UNIQUE INDEX IDX_BAS_FLEXVALUESDETAIL_U ON T_BAS_FLEXVALUESDETAIL (FF100011, FF100012, FF100013, FF100014, FF100015, FF100016, FF100017, FF100018, FF100019, FF100020, FF100021, FF100022, FF100023, FF100024, FF100025, FF100026, FF100027, FF100028, FF100029, FF100030, FF100031, FF100032, FF100033, FF100034, FF100035, FF100036, FF100037, FF100038, FF100039, FF100040, FF100041, FF100042, FF100043, FF100044, FF100045, FF100046, FF100047, FF100048, FF100049, FF100050, FF100051, FF100052, FF100053, FF100054, FF100055, FF100056, FF100057, FF100058, FF100059, FF100060, FF100061, FF100062, FF100063
请总部尽快给处理一下,我QQ:1092450624
推荐阅读