KM项目更新SEQ的SQL

Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_BID) Where s.sequence_name='KM_BID';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_BTYPE) Where s.sequence_name='KM_BTYPE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_CHECK_GROUP) Where s.sequence_name='KM_CHECK_GROUP';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_KNOWLEDGE) Where s.sequence_name='KM_KNOWLEDGE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_KNOWLEDGE_ATTACH) Where s.sequence_name='KM_KNOWLEDGE_ATTACH';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_PERSONALFAVOR) Where s.sequence_name='KM_PERSONALFAVOR';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_TN_KNOWLEDGE) Where s.sequence_name='KM_TN_KNOWLEDGE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_TREE_NODE) Where s.sequence_name='KM_TREE_NODE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_TREE_NODE_POWER) Where s.sequence_name='KM_TREE_NODE_POWER';