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

发表于:2007-06-07来源:作者:点击数: 标签:

MILY: 宋体; mso-bidi-font-size: 8.5pt">Set oRs = oCn.Execute("SET NOCOUNT ON;INSERT INTO Products (ProductName) VALUES ('Chalk');SELECT IDENTITY") 

lProductID = oRs(0)

原文转自:http://www.ltesting.net