DELETE FROM bbsnews WHERE (boardid NOT IN(SELECT id FROM board))

来源：百度知道编辑：UC知道时间：2024/05/26 11:23:34

这句话写在asp文件里面，应该如何写呢？

dim conn
set conn=server.CreateObject("ADODB.connection")
connStr=你的数据库连接字符串
conn.open connStr
conn.Execute "DELETE FROM bbsnews WHERE (boardid NOT IN(SELECT id FROM board))"

conn.Execute "DELETE FROM bbsnews WHERE (boardid NOT IN(SELECT id FROM board))"

如何恢复sqlserver2005 delete from 数据 sybase 数据库操作 delete from where 如果delete form不加表名会出现什么后果 sqldel="delete from book where id="&request("id") exec="delete * from guestbook where id="&request.form("id")" rs.open "delete * from NEWS where id="&request("id"),conn,1 SQL SERVER 2000我不小心执行了DELETE FROM 后面没根参数,怎么办 SqlStmt = "DELETE FROM Customer WHERE CustId='" + Trim(TmpId) + "'" delete from “表名”时说对象名“表名”无效什么意思？ conn.execute("delete * from SMT_sca where SMT_key1=0 and SMT_enrol=3") sql = "select count(ry_id) from ry_content inner join bbs on ry_content.ry_id=bbs.id "