△insertintoA(a,b,c)va...... insert into A(a,b,c)values('a','b','c') select top 1 ID from A order by ID desc 上面是一种方法 insert into A(a,b,c)values('a','b','c') select @@IDENTITY 这中方法好象只适用MS SQL数据库 ACC里面我没试过,大家可以试一下 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 19:25 , Processed in 0.260610 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.