34,873
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
bestmai 2004-11-06
- 打赏
- 举报
thx a lot
niuniuma 2004-11-06
- 打赏
- 举报
学习.
qijiangyou 2004-11-06
- 打赏
- 举报
delete t1 from t1 a
where ( select count(*) from t1 b where a.列1 = b.列1 and a.列2 = b.列2 and ... ) > 1
where ( select count(*) from t1 b where a.列1 = b.列1 and a.列2 = b.列2 and ... ) > 1
leech125 2004-11-06
- 打赏
- 举报
先计算@count, 然后再删除@count > 1的
csdnshao 2004-11-06
- 打赏
- 举报
select distinct * into temp1 from t1
delete from t1
insert into t1 select * from temp1
drop table temp1
delete from t1
insert into t1 select * from temp1
drop table temp1
xiuxiuzi 2004-11-06
- 打赏
- 举报
不知道楼主是否想保留相同记录中的一条?如果保留的话
select distinct * into temp1 from t1
delete from t1
insert into t1 select * from temp1
select distinct * into temp1 from t1
delete from t1
insert into t1 select * from temp1
xingfuniao 2004-11-06
- 打赏
- 举报
建立存储过程
create procedure MyP
as
select * into #t
from (select * from 表 union select * from 表) b
delete 表
insert into 表 select * from #t
drop table #t
go
exec MyP
create procedure MyP
as
select * into #t
from (select * from 表 union select * from 表) b
delete 表
insert into 表 select * from #t
drop table #t
go
exec MyP
光原 2004-11-06
- 打赏
- 举报
1。在企业管理器把表新加一列timesamp类型，
2。再删除那行，
3。接下来删除新加的列（timesamp类）型。
2。再删除那行，
3。接下来删除新加的列（timesamp类）型。
bestmai 2004-11-06
- 打赏
- 举报
up
