我的这个游标第三个记录有2个，为什么

[sisiz]

declare @strName varchar(100)

declare str_cur CURSOR
FOR select * from dbo.f_split('1:2:3',':')
OPEN str_cur

FETCH NEXT FROM str_cur INTO @strName
select @strName
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=1

while @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM str_cur INTO @strName
select @strName
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=@strName

END

CLOSE str_cur
deallocate str_cur

[sp4]

declare @strName varchar(100)

declare str_cur CURSOR
FOR select * from dbo.f_split('1:2:3',':')
OPEN str_cur

FETCH NEXT FROM str_cur INTO @strName
--select @strName
--UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=1

while @@FETCH_STATUS=0
BEGIN

--select @strName
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=@strName

FETCH NEXT FROM str_cur INTO @strName

END

close str_cur
deallocate str_cur

[sp4]

declare @strName varchar(100) 

declare str_cur CURSOR 
FOR select * from dbo.f_split('1:2:3',':') 
OPEN str_cur 

FETCH NEXT FROM str_cur INTO @strName 
--select @strName 
--UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=1 

while @@FETCH_STATUS=0 
BEGIN 

--select @strName 
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=@strName 

FETCH NEXT  FROM str_cur INTO @strName 

END 

close str_cur 
deallocate str_cur 

[中国风]

FETCH NEXT FROM str_cur INTO @strName
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=1

while @@FETCH_STATUS=0
BEGIN
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=@strName
FETCH NEXT FROM str_cur INTO @strName
END

--FETCH NEXT FROM str_cur INTO @strName的順序

[terrybogero]

你没搞好下面两个的关系,
FETCH NEXT FROM str_cur INTO @strName
while @@FETCH_STATUS=0

@@FETCH_STATUS=0这个是表示游标FETCH NEXT FROM str_cur INTO @strName正常下移
,仔细感觉一下你的循环,它会在最后一条记录上处理两次,因为最后一次是在@@FETCH_STATUS<>0的时候处理的!

[SQLnewlearner]

[Quote=引用楼主 sisiz 的帖子:]


declare @strName varchar(100)

declare str_cur CURSOR
FOR select * from dbo.f_split('1:2:3',':')
OPEN str_cur

FETCH NEXT FROM str_cur INTO @strName
select @strName --删除
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=1 --删除

while @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM str_cur INTO @strName
select @strName
UPDATE tbDicInclude set OoperationTagc=0 WHERE ItemID=@strName …
[/Quote]