游标的问题

[linguojin11]

create table lin(id int ,name varchar(100))
insert into lin select 1,'a'
INSERT INTO LIN SELECT 2,'B'
go
declare tcursor cursor for select name from lin
declare @a varchar(100)
open tcursor
fetch next from tcursor into @a
WHILE @@FETCH_STATUS = 0
BEGIN

declare @a1 table(name varchar(100))
insert @a1(name) values(@a)

FETCH NEXT from tcursor into @a
print @a --------------------注意点
END
close tcursor
deallocate tcursor

go
drop table lin
-----------------------------------
结果是：(1 行受影响)
B

(1 行受影响)
B
-------------------------------------------

----------------------------------------------------------------------------------------------


create table lin(id int ,name varchar(100))
insert into lin select 1,'a'
INSERT INTO LIN SELECT 2,'B'
go
declare tcursor cursor for select name from lin
declare @a varchar(100)
open tcursor
fetch next from tcursor into @a
WHILE @@FETCH_STATUS = 0
BEGIN

declare @a1 table(name varchar(100))
insert @a1(name) values(@a)

FETCH NEXT from tcursor ----不同之处在这里
print @a
END
close tcursor
deallocate tcursor

go
drop table lin
---------------------------------------------

(1 行受影响)
name
----------------------------------------------------------------------------------------------------
B

(1 行受影响)

a

(1 行受影响)
name
----------------------------------------------------------------------------------------------------

(0 行受影响)

a
-----------------------------------------------------------------------------

[-狙击手-]

declare tcursor cursor for select name from lin 
declare @a varchar(100) 
open tcursor 
fetch next  from tcursor into @a 
WHILE @@FETCH_STATUS = 0  
BEGIN 
      
        declare @a1 table(name varchar(100)) 
        insert  @a1(name) values(@a) 
        print @a 
        fetch next  from tcursor into @a 
        
END 
close tcursor 
deallocate tcursor 

[Four]

想说什么?

[-狙击手-]

declare tcursor cursor for select name from lin 
declare @a varchar(100)
declare @a1 table(name varchar(100))  
open tcursor 
fetch next  from tcursor into @a 
WHILE @@FETCH_STATUS = 0  
BEGIN 
      
        
        insert  @a1(name) values(@a) 
        print @a 
        fetch next  from tcursor into @a 
        
END 
close tcursor 
deallocate tcursor

[让你望见影子的墙]

正常，执行过程如下：以第一个为例
1、第一个fetch 得到a，插入以后，再fetch 得到B，那么打印自然是B，取下一条成功后，继续循环，插入以后，取下一条不成功，所以@a依然是B，打印的自然还是B，因为读取下一条不成功，退出循环。

[linguojin11]

[Quote=引用 4 楼 herowang 的回复:]
正常，执行过程如下：以第一个为例
1、第一个fetch 得到a，插入以后，再fetch 得到B，那么打印自然是B，取下一条成功后，继续循环，插入以后，取下一条不成功，所以@a依然是B，打印的自然还是B，因为读取下一条不成功，退出循环。
[/Quote]
大哥,第2个例子呢...

[linguojin11]

大哥,第2个例子呢...