摘要: 不同数据库获取新增加的主键值 数据库获取新增主键的查询语句DB2IDENTITY_VAL_LOCAL()InformixSELECT dbinfo('sqlca.sqlerrd1') FROM <TABLE>SybaseSELECT @@IDENTITYSqlServerSELECT SCOPE_IDENTITY()或SELECT @@IDENTITYMySqlSELECT LAST_INSERT_ID()HsqlDBCALL IDENTITY()CloudscapeIDENTITY_VAL_LOCAL()DerbyIDENTITY_VAL_LOCAL()Postg 阅读全文
posted @ 2011-04-02 19:30 gisdream 阅读(475) 评论(0) 推荐(0) 编辑