FireBird使用记录

最新推荐文章于 2018-05-24 16:53:00 发布

CodingSir

最新推荐文章于 2018-05-24 16:53:00 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

文章标签： insert generator

本文链接：https://blog.youkuaiyun.com/educast/article/details/6401401

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