摘要:
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 ... 阅读全文