消除重复纪录的存储过程

[aboayan]

如何写一个通用的存储过程,给存储过程一个表名(字符型的参数),然后将该表中的重复记录消除掉(多条重复纪录保存一条).

[zjcxc]

create procedure pdelrepeated
@tbname --要去掉重复记录的表
as
declare @sql varchar(8000)
set @sql1='select distinct * into #tb from '+@tbname
+char(13)+'delete from '+@tbname
+char(13)+'insert into '+@tbname+' select * from #tb'
exec(@sql)

[friendliu]

create proc test @tablename varchar(12)

as
declare @sql varchar(800)
set @sql='select distinct * into #tem from '+@tablename+''
exec(@sql)
exec('delete from '+@tablename'')
exec('select * into '+@tablename+' from #tem')
drop table @tem
go

[ls_hndd]

Create Procedure test (@TableName varchar(50))
as
exec('select distinct * from '+@tablename)
go

调用：test @TableName = '你的表'