利用存储过程-数据库专栏,SQL Server

利用存储过程来消除数据库中冗余的数据
create procedure sp_mytest as
declare @pro varchar(50)
declare @mm int
declare wu cursor for select distinct product from mytest
open wu
fetch next from wu into @pro
while @@fetch_status=0
begin
 select @mm=sum([cost]) from mytest where [product]=@pro
 delete from mytest where [product]=@pro
 insert into mytest ([product],[cost]) values(@pro,@mm)
 
 fetch next from wu into @pro
end
close wu
deallocate wu
go
我们可以使用作业进行相应的数据的更新