摘要： 1、按条件查找：select * from OA_GROUP_H t WHERE TAXIS between 1000 and 1015select * from OA_GROUP_H t WHERE TAXIS=‘1000’2、查找按降序进行排列：select * from OA_GROUP_H t order by TAXIS DESC3、插入数据：insert into OA_GROUP_H(GROUP_ID,NAME,PARENT_ID,TAXIS,GROUP_TYPE,GROUP_LEVEL,GROUP_TAG,FULL_NAME)SELECT * FROM OA_GROU... 阅读全文

摘要： EXEC SQL INCLUDE SQLCA;//通讯区 EXEC SQL WHENEVER SQLERROR GOTO sqlerr;//错误情况下，处理 //说明段，包括：类型说明语句 EXEC SQL BEGIN DECLARE SECTION; VARCHAR vcConnStr[512]; /*数据库连接串 user/pwd@sid*/ VARCHAR vcLinkName[64]; /*数据库连接别名*/ sql_context ctx = NULL; /*数据库连接上下文*/ EXEC SQL ... 阅读全文