delete在sql server与access中的区别

SQL Server中：

set rs=server.createobject("adodb.recordset")

if request("del")<>"" then conn.Execute("delete from PROJECT where PROJECT_ID='"&request("del")&"'")

access中:

set rs=server.createobject("adodb.recordset")

if request("del")<>"" then conn.Execute("delete * from PROJECT where PROJECT_ID='"&request("del")&"'")

posted on 2005-10-16 21:22 晒太阳阅读(1085) 评论(0) 编辑收藏举报