declare mycur scroll cursor as select * from yourtable where orderid =10520 --假设关键字是ORDERID,10520有两条相同的记录!
OPEN MYCUR
FETCH ABSOLUTE=2 FROM MYCUR
DELETE yourtablename WHERE CURRENT OF MYCUR
CLOSE MYCUR
DEALLOCATE MYCUR
OPEN MYCUR
FETCH ABSOLUTE=2 FROM MYCUR
DELETE yourtablename WHERE CURRENT OF MYCUR
CLOSE MYCUR
DEALLOCATE MYCUR
go
select distinct * into newTable from yourTable;
go
drop table yourTable;
go
exec sp_rename 'newTable','yourTable'
这段指令中的'select into/bulkcopy',true; 是社么意思,