删除重复数据

 

declare @max integer,@hotel_id integer,@room_name nvarchar(100)

declare cur_rows cursor local for select room_name,hotel_id,count(*) from hotel_room  group by hotel_Id,room_name having count(room_name)>1


open cur_rows

fetch cur_rows into @room_name,@hotel_id,@max

while @@fetch_status=0

begin

select @max = @max -1

set rowcount @max

delete from hotel_room where hotel_id = @hotel_id and room_name=@room_name

fetch cur_rows into @room_name,@hotel_id,@max

end

close cur_rows

set rowcount 0