首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

一堆您看不懂的SQL

2013-07-11 
一堆你看不懂的SQL/*ID2*/SELECTo.GROUP_IDFROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID o.

一堆你看不懂的SQL

/*ID2*/SELECT  o.GROUP_ID  FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10)/*ID6*/SELECT OBJECT_ID  FROM GLX_C_OBJECTS WHERE CLASS_ID  in (SELECT CLASS_ID  as newContext FROM GLX_C_CLASSES WHERE NETWORK_ID in (SELECT c.NETWORK_ID FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))AND        cast(CONTENT as varchar(32000)) like '%ActivationDeadlineIntermediateTimerE%'  ) AND GROUP_ID in(SELECT o.GROUP_ID  FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))SELECT JOB_ID FROM GLX_C_JOBS WHERE OBJECT_ID in(SELECT OBJECT_ID  FROM GLX_C_OBJECTS WHERE CLASS_ID  in (SELECT CLASS_ID  as newContext FROM GLX_C_CLASSES WHERE NETWORK_ID in (SELECT c.NETWORK_ID FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))AND        cast(CONTENT as varchar(32000)) like '%ActivationDeadlineIntermediateTimerE%'  ) AND GROUP_ID in(SELECT o.GROUP_ID  FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10)))

热点排行