Access中可以用Select @@Identity
Sqlite中貌似不行,异常:System.Data.SQLite.SQLiteException: SQLite error unrecognized token: "@"谁能给一个适用于所有数据库的通用解决方案,谢谢!
Sqlite中貌似不行,异常:System.Data.SQLite.SQLiteException: SQLite error unrecognized token: "@"谁能给一个适用于所有数据库的通用解决方案,谢谢!
go
insert into T1(field2, field3) values('a', 1)
go
select * from t1;
go
drop table t1
go@@IDENTITY LAST_INSERT_ROWID()