select distinct * into temptable from tablename
go
truncate table tablename
go
insert into tablename select * from temptable
go
drop table temptable
go
go
truncate table tablename
go
insert into tablename select * from temptable
go
drop table temptable
go
假定表为TABLE,字段为: FIELD1,FIELD2,FIELD3SELECT DISTINCT A.FIELD1,A.FIELD2,B.FIELD3
FROM
(SELECT FIELD1,FIELD2,FIELD3 FROM TABLE) B INNER JOIN
( SELECT DISTINCT FIELD1,FIELD2 from TABLE) A ON B.FIELD1=a.FIELD1 AND B.FIELD2=a.FIELD2
不行啊.
select distinct * into temptable from tablename
go
truncate table tablename
go
insert into tablename select * from temptable
go
drop table temptable
go
FROM
(SELECT MovieID,Name,FilePath FROM path) B INNER JOIN
( SELECT DISTINCT MovieID,Name from path) A ON B.MovieID=a.MovieID AND B.Name=a.Name但结果不变,仍有重复:
1 杀科 \\xie\g\133\VTS_15_1.VOB
1 杀科 \\xie\g\258\Part_3_1.vob
SQL SERVER 报:服务器: 消息 4708,级别 16,状态 1,行 1
未能截断对象 'path',因为该对象不是表。
服务器: 消息 4405,级别 16,状态 2,行 1
视图或函数 'path' 不可更新,因为修改会影响多个基表。没办法,我的是View