ASP
+
Access2000
![None.gif](/Images/OutliningIndicators/None.gif)
1
.要获取的ID值字段属性必须设为:自动编号(我们假设字段名为recordID)
![None.gif](/Images/OutliningIndicators/None.gif)
2
.添加记录格式:Rs.
Open
table
,Cn,
1
,
3
注意模式为:
1
,
3
![None.gif](/Images/OutliningIndicators/None.gif)
3
.
newID
=
rs.Fields("recordID")
![None.gif](/Images/OutliningIndicators/None.gif)
4
.newID为刚添加的记录的ID值
![None.gif](/Images/OutliningIndicators/None.gif)
ASP
+
SQL Server
2000
![None.gif](/Images/OutliningIndicators/None.gif)
1
.要获取的ID值字段属性必须设为:自动编号(我们假设字段名为recordID)
![None.gif](/Images/OutliningIndicators/None.gif)
2
.添加记录代码模式:
![None.gif](/Images/OutliningIndicators/None.gif)
Cn.
Execute
"
INSERT
INTO
table
(field1,field2,
)
VALUES
("field1Value","field2Value",
)"
![None.gif](/Images/OutliningIndicators/None.gif)
3
.得到ID值
![None.gif](/Images/OutliningIndicators/None.gif)
Set
Rss
=
Cn.
Execute
("
SELECT
SCOPE_IDENTITY
()
as
newIDValue
FROM
table
")
'
Rs.Open sqlStr,Cn,3,1
newID = Rss("newIDValue")
![None.gif](/Images/OutliningIndicators/None.gif)
4.newID为刚添加的记录的ID值
![None.gif](/Images/OutliningIndicators/None.gif)
5.附上取得ID值的三种方式:
![None.gif](/Images/OutliningIndicators/None.gif)
/* 对于想要得到一个表中的最后一个插入操作所产生的ID的最好用IDENT_CURRENT(
'
TBName
'
)*/
INSERT INTO table(field1,field2,
) VALUES("field1Value","field2Value",
) SELECT IDENT_CURRENT(
'
recordID
'
) as newIDValue
![None.gif](/Images/OutliningIndicators/None.gif)
/*对于马上使用的刚才插入的新记录ID用SCOPE_IDENTITY()是最合适的*/
INSERT INTO table(field1,field2,
) VALUES("field1Value","field2Value",
) SELECT SCOPE_IDENTITY() as newIDValue
![None.gif](/Images/OutliningIndicators/None.gif)
/*对于想要得到一系列的操作中最后得到的那个自增的ID最好用@@IDENTITY*/
INSERT INTO table(field1,field2,
) VALUES("field1Value","field2Value",
) SELECT @@IDENTITY as newIDValue
转载于:https://www.cnblogs.com/xzlang/archive/2006/06/01/414743.html