declare @ varchar(8000)
set @=''
select @=@+rtrim(name)+',' from syscolumns where id=object_id('你的表名') and name<>'你不想要的那个编号列如id'
set @=left(@,len(@)-1)
exec('select '+@+' from 你的表名 group by '+@+' having count(*)>1')
-----------------------------------------------------------------
你用dts吗?那你dts服务的“启动”用户要对对方有共享的权限!
declare @ varchar(8000)
set @=''
select @=@+rtrim(name)+',' from syscolumns where id=object_id('你的表名') and name<>'ID'
set @=left(@,len(@)-1)
exec('select '+@+' from 你的表名 group by '+@+' having count(*)>1')