Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
minhle
Starting Member
4 Posts |
 Posted - 2011-11-03 : 18:39:25
|
| dear allI want to use data (Autonumber) after insert into table but I have no way. Exam I have table abcd(ID, name) where ID is autonumber.I insert by this commandInsert into abcd(name) values ('my text')after inserted, I want to use the value of autonumer ID. How can I do?I write by the old way but cannot run:rs.addnewrs("name") = "my text"rs.updateresponse.write rs("ID")Who know the way and help me? I am new in SQL ... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
minhle
Starting Member
4 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
minhle
Starting Member
4 Posts |
Posted - 2011-11-03 : 21:22:52
|
| Anybody can help me? |
 |
|
|
|
|
|
Using data after insert into table