22,210
社区成员
发帖
与我相关
我的任务
分享
strSQL = "BEGIN TRAN SELECT * FROM TT WITH (tablockx)"
'strSQL = "select count(*) from NewComputer with(tablockx)"
Set ADResult =DBconn.Execute(strSQL)
If Err <> 0 Then
errMsg = " 数据库JoinDomainInfo连接失败!请联系管理员。"
Err.Raise vbObjectError + 1011
Err.Description = errMsg
Err.Source = "域控制器连接"
ShowError()
MsgBox Err.Number & Err.Description
'WScript.Quit
End If
While Not ADResult.EOF
For i = 0 To ADResult.Fields.Count -1
MaxComputerName = ADResult(i).value
Next
ADResult.MoveNext
Wend
strSQL = "COMMIT TRAN insert into TT (ID) values ('11')"
Set ADResult =DBconn.Execute(strSQL)
If Err <> 0 Then
errMsg = " 数据库JoinDomainInfo连接失败!请联系管理员。"
Err.Raise vbObjectError + 1011
Err.Description = errMsg
Err.Source = "域控制器连接"
ShowError()
MsgBox Err.Number & Err.Description
'WScript.Quit
End If
第二个查询无法进行了...