无法删除的,建议将先将记录导入到一临时表,然后清空表,在从临时表导回该表。
比如: select DISTINCT * into temp from table1
delete from table1 insert into table1
select * from temp
比如: select DISTINCT * into temp from table1
delete from table1 insert into table1
select * from temp
相信我吧。兄弟
sql="select * form tble1 order by Name desc"
set rs=conn.execute(sql)
tmpk=""
do while not rs.eof
if trim(rs("Name"))<>tmpk then
conn.execute("insert into .....")
end if
tmpk=trim(rs("Name"))
loop
set rs=nothing哪位大哥最好把他改成 存储过程 的,方便调用