sqlserver中插入值后,马上得到自动编号的值......

Set oRs = oCn.Execute("SET NOCOUNT ON;INSERT INTO Products (ProductName) VALUES ('Chalk');SELECT IDENTITY")

lProductID = oRs(0)