DB2与 SQLSERVER的自增

来源:互联网 发布:php开源商城源码 编辑:程序博客网 时间:2024/05/21 15:38
/*自增序列:
   DB2:
       create table TestTable
       (
        recordindex  integer identity generated as always,
        stringDateTime  varchar(50),
        TrueDateTime timestamp
       );
   SQLServer:
      create table TestTable
      (
       recordindex  int identity,
       stringDateTime  varchar(50),
       TrueDateTime datetime
      )
/*自增返回
    SQLServer: "SELECT @@IDENTITY"
    DB2:"select max(序号) from TableA" 
原创粉丝点击