增加文章后立刻得到该文章ID
这个问题时而碰到,但是到今天工作上用到了,才真正了解了其中的意义,所谓ID其实就是自增的那个字段而已。呵呵!
Set Rss = Conn.Execute("SELECT SCOPE_IDENTITY() as newIDValue FROM TB_A")
newID = Rss("newIDValue")
Set Rss = Conn.Execute("SELECT SCOPE_IDENTITY() as newIDValue FROM TB_A")
newID = Rss("newIDValue")