sql ÓРɾ³ýa±íµÄ¼Ç¼ È»ºó°Ñɾ³ýµÄ¼Ç¼Ìí¼Óµ½b±íµÄ Óï¾äÂð

ïLß^aiqŸoºÛ

sql  ÓРɾ³ý A ±íµÄ¼Ç¼ È»ºó°Ñɾ³ýµÄ¼Ç¼Ìí¼Óµ½ B ±íµÄ Óï¾äÂð

ÏÖÔÚ Óиö±í ÏÔʾÔÚ Ò³Ãæa ÀïÃæ  Ò»ÌõÌõ¼Ç¼
Óû§Ñ¡ÔñÁË A ÀïµÄ Ò»Ìõ¼Ç¼  sql Óï¾ä¾Í°Ñ Ñ¡ÔñµÄÄÇÌõ¼Ç¼ ´Ó A ±í ɾ³ý   Ìí¼Óµ½b±í

Æäʵ¾ÍÊÇ´Ó A ±í¼ôÇÐÊý¾Ýµ½ B ±í  ¸ÃÔõôд?

µ¼ÑÝ

<%
If Session("name")="" Then
  Response.Redirect "Login.asp"
End if
%>
<%
dim id,addtime
ID=request("checkid")
addtime=date()


dim rstemp,rsadd,rsdel
dim tname,title,tel
dim main
dim mobile
dim department
dim email,office
set rstemp=server.createobject("adodb.recordset")
set rsadd=server.createobject("adodb.recordset")
set rsdel=server.createobject("adodb.recordset")
Dim conn
conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\text\database\text.mdb"
sqltemp="select * from ÂÛÎÄÐÅÏ¢"
rstemp.Open sqltemp,conn,1,1
if rstemp.EOF or rstemp.BOF then
    response.write "<script language=JavaScript>" & chr(13) & "alert('ÕⱾͼÊéÒÑÊÛÍ꣡');" & "history.back()" & "</script>"
else
    tname=rstemp("tname")   
    title=rstemp("title")
    tel=rstemp("tel")
    main=rstemp("main")
    mobile=rstemp("mobile")
    department=rstemp("department")
    email=rstemp("email")
    office=rstemp("office")
sql="insert into list(tname,title,name,tel,main,mobile,department,email,office,addtime) values('"&tname&"','"&title&"','"&session("name")&"','"&tel&"','"&main&"','"&mobile&"','"&department&"','"&email&"','"&office&"','"&addtime&"')"
rsadd.open sql,conn,1,1
set rsdel=server.createobject("adodb.recordset")

sql="delete  from ÂÛÎÄÐÅÏ¢ where title in (select title from list)"
rsdel.open sql,conn,3,4



response.write "<script language=JavaScript>" & chr(13) & "alert('¿Î³ÌÒÑÌí¼Ó£¡');" & "history.back()" & "</script>"
set rstemp=nothing
set rsadd=nothing
set rsdel=nothing
set conn=nothing
end if
%>


ÎҵĴúÂëÊÇÕâÑùдµÄ ÄÜÌí¼Ó µ«É¾³ý²»ÁË

¼Ó·Çè

select * into B from A where condition   'Ïȸ´ÖÆ
delete * from A where condition 'ÔÙɾ³ý±íAÏëɾ³ýµÄÊý¾Ý

¾ø²»·ÅÆú

ÐÐÁË ºÇºÇ
¸Ä
sql="delete * from ÂÛÎÄÐÅÏ¢ where title in (select title from list)"
rsdel.open sql,conn,1,3

ØüÔÕvsØüÔÕ

ÕâÖÖ Óï¾äÄÜ Ð´³É ÕâÑùÂð

select * into B from A where condition and delete * from A where condition

µ±ÖÐÓÐand Á¬½Ó  ¿ÉÒԵĻ° ÏȺó˳ÐòÊÇÉõô?

Èç¹û²»ÄܵĻ°  ÎÒÒªÓà ASP ʵÏÖ  µ±Ñ¡Ôñ A ±íÀïµÄ Ò»Ìõ¼Ç¼ ¾ÍÄÜ Ìí¼Óµ½ B ±íÀï  È»ºó°Ñ A ±íµÄÄÇÌõ¼Ç¼ɾ³ý

Ougeng

Ö§³Öһϰɣ¬È·ÊµÊDz»´íµÄÌù×Ó¡£