select ditinct Fkey,code into TableName1 from TableName
go
drop table TableName
go
sp_rename 'TableName1','TableName'
go
go
drop table TableName
go
sp_rename 'TableName1','TableName'
go
调试欢乐多
select distinct fkey,code form tablenamedelete tablename
insert into tablename
select * from #temp
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'mp_delete_repeat'
AND type = 'P')
DROP PROCEDURE mp_delete_repeat
GOCREATE PROCEDURE mp_delete_repeat
@TableName sysname=null
AS
if not exists(select name from sysobjects where name=@TableName and type='U')
return(1)
exec('select distinct * into #temp from '+@TableName)
exec('delete '+@TableName)
exec('insert into '+@TableName+'select * from #temp')
GO