1、批量执行Insert
EXECUTE BLOCK AS BEGIN
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (2, 500, 2000, 10, 25);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (3, 2000, 5000, 15, 125);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (4, 5000, 20000, 20, 375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (5, 20000, 40000, 25, 1375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (6, 40000, 60000, 30, 3375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (7, 60000, 80000, 35, 6375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (8, 80000, 100000, 40, 10375);
insert into T_GZTAX (TAXID, "MIN", "MAX", RATE, MINUSNUM)
values (9, 100000, 500000, 45, 15375);
end
2、保留关键字要加“” 使用 例如上面的:MIN 要使用"MIN"
3、字符串转时间
CAST('05-05-2011 17:00:16' AS timestamp)
4、Generator
create sequence SEQUENCE_T_GZFUNCAUTH
SET GENERATOR SEQUENCE_T_GZBASEINFO TO 1051