sqlserver中插入值后,马上得到自动编号的值......
Set oRs = oCn.Execute("SET NOCOUNT ON;INSERT INTO Products (ProductName) VALUES ('Chalk');SELECT IDENTITY")
lProductID = oRs(0)
Set oRs = oCn.Execute("SET NOCOUNT ON;INSERT INTO Products (ProductName) VALUES ('Chalk');SELECT IDENTITY")
lProductID = oRs(0)