/*自增序列:
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"
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"