Çë½Ìdelphiɾ³ýÁÙʱ±íµÄÎÊÌâ

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[temp1]
GO

ÉÏÃæÊÇSQLÖÐÉú³É±íʱµÄɾ³ý±í½Å±¾£¬ÎÒÏëÎÊÏÂÕâ¶ÎÅжÏÓï¾äÔÚdelphiÖоßÌåÓ¦¸ÃÔõôʵÏÖ¡£
ÏÂÃæɾ³ýÓï¾äûÓмӱíÃûÊÇ·ñ´æÔÚµÄÅжϣ¬ÅжÏÓ¦¸ÃÒªÔõô¼Ó£¿
/*
¼ÓÈëÅжϣ¬±í´æÔÚÔòɾ³ý
*/
with dm.bsbaobiaoqry1 do begin
close;
sql.Clear;
sql.Add('drop table T_bswxtabletemp');
execsql;
end;

with dm.bsbaobiaoqry1 do begin
  close;
  sql.Clear;
  sql.Add('select * into T_bswxtabletemp from T_scanjobdetail');
  execsql;
end;

---

sql.Add('if exists select * from T_bswxtabletemp drop table T_bswxtabletemp')

---

ÒýÓÃ

with dm.bsbaobiaoqry1 do begin
close;
sql.Clear;
sql.Add('if exists (select * from dbo.sysobjects where id = object_id(N'+#39+'[dbo].[T_bswxtabletemp]'+#39+') and OBJECTPROPERTY(id, N'IsUserTable') = 1) ')
sql.Add('Add('drop table T_bswxtabletemp');
execsql;
end;

up~

---

лл£¬ÎÒÊÔÊÔ¿´