__Query := QuerySQL(DM.AdoConn,'sp_who'); if Assigned(__Query) then begin try if not __Query.IsEmpty then begin __Query.first; with __Query do while not eof do begin if lowerCase(Trim(fieldbyname('dbname').AsString)) = LowerCase(Trim(DM.DataBase)) then begin ExecuteSQL(DM.AdoConn,'kill '+fieldbyname('spid').AsString); end; next; end; end; finally FreeAndNil(__Query); end; end; sleep(2000); //睡2秒
if Assigned(__Query) then
begin
try
if not __Query.IsEmpty then
begin
__Query.first;
with __Query do while not eof do
begin
if lowerCase(Trim(fieldbyname('dbname').AsString)) = LowerCase(Trim(DM.DataBase)) then
begin
ExecuteSQL(DM.AdoConn,'kill '+fieldbyname('spid').AsString);
end;
next;
end;
end;
finally
FreeAndNil(__Query);
end;
end;
sleep(2000); //睡2秒