sql 游标用法一

declare @mergedate datetime 
declare @masterid int 
declare @duplicateid int

select @mergedate = getdate()

declare merge_cursor cursor fast_forward for select mastercustomerid, duplicatecustomerid from duplicatecustomers where ismerged = 0 
--定义一个游标对象[merge_cursor] 
--该游标中包含的为:[select mastercustomerid, duplicatecustomerid from duplicatecustomers where ismerged = 0 ]查询的结果.

open merge_cursor 
--打开游标 
fetch next from merge_cursor into @masterid, @duplicateid 
--取数据到临时变量 
while @@fetch_status = 0 --系统@@fetch_status = 0 时循环结束 
--做循环处理 
begin 
exec mergeduplicatecustomers @masterid, @duplicateid

update duplicatecustomers 
set 
ismerged = 1, 
mergedate = @mergedate 
where 
mastercustomerid = @masterid and 
duplicatecustomerid = @duplicate