我用SQL得到一个记录集,然后对记录集中的某些记录进行更新,发现数据库也被更新,如何只更新记录集而不更新数据库,代码如下:
dim myRecord as new RecordSet
dim Sql as StringSql="select * from 表1"
myRecord.Open Sql,CNN,1,3Do While Not myRecord.EOF
If Trim(myRecord("名称")) = "你好" Then myRecord("名称") = "您好"
myRecord.MoveNext
Loop
dim myRecord as new RecordSet
dim Sql as StringSql="select * from 表1"
myRecord.Open Sql,CNN,1,3Do While Not myRecord.EOF
If Trim(myRecord("名称")) = "你好" Then myRecord("名称") = "您好"
myRecord.MoveNext
Loop
update #tb set...
SELECT * INTO 临时表 from 原表
UPDATE 临时表 SET 需要更新的内容