query1...
query1.sql.add('select id from table1');
query1.open;
query1.last;showmessage(inttostr(query1.fieldbyname('id').asinteger));
query1.sql.add('select id from table1');
query1.open;
query1.last;showmessage(inttostr(query1.fieldbyname('id').asinteger));
Oracle的话可以用序列
sqlserver 的自增字段到底怎么设啊?
http://www.csdn.net/expert/topic/824/824319.xml?temp=.6137201
sql server 的自增字段怎么设置?请看帖子:
http://www.csdn.net/expert/topic/824/824319.xml?temp=.1532251
http://www.csdn.net/expert/topic/824/824319.xml?temp=.1532251你的自动增长字段要设成不允许为空,也就是要将null选项去掉。
insert into test values('a')
delete test
select @@identity
即可