小弟的代码要实现打印出社区的ID号和社区所有者的ID号,为什么小弟最后PRINT出的记录是最后一条,而不是所有的?小弟希望能取的所有的ID号,做为参数来使用,求教
打印的结果是这样的
ID UID
--------------------
33
10
33
10declare @Id int --社区ID号
declare @UId int --社区所有者ID号
declare Crop_cursor Cursor for select JeCorp_Id,JeCorp_UID from JEClubView_SelectUserCrop
OPEN Crop_cursor
FETCH next FROM Crop_cursor into @Id,@UId
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Crop_cursor into @Id,@UId
print @Id
print @UId
END
CLOSE Crop_cursor
DEALLOCATE Crop_cursor
打印的结果是这样的
ID UID
--------------------
33
10
33
10declare @Id int --社区ID号
declare @UId int --社区所有者ID号
declare Crop_cursor Cursor for select JeCorp_Id,JeCorp_UID from JEClubView_SelectUserCrop
OPEN Crop_cursor
FETCH next FROM Crop_cursor into @Id,@UId
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Crop_cursor into @Id,@UId
print @Id
print @UId
END
CLOSE Crop_cursor
DEALLOCATE Crop_cursor
declare @Id int --社区ID号
declare @UId int --社区所有者ID号
declare Crop_cursor Cursor for select JeCorp_Id,JeCorp_UID from JEClubView_SelectUserCrop
OPEN Crop_cursor
FETCH next FROM Crop_cursor into @Id,@UId
WHILE @@FETCH_STATUS = 0
BEGIN
print @Id
print @UId
FETCH NEXT FROM Crop_cursor into @Id,@UId
END
CLOSE Crop_cursor
DEALLOCATE Crop_cursor
declare @UId int --社区所有者ID号declare Crop_cursor Cursor for select JeCorp_Id,JeCorp_UID from JEClubView_SelectUserCrop
OPEN Crop_cursor
FETCH next FROM Crop_cursor into @Id,@UId
WHILE @@FETCH_STATUS = 0
BEGIN
print @Id
print @UId
FETCH NEXT FROM Crop_cursor into @Id,@UId
END
CLOSE Crop_cursor
DEALLOCATE Crop_cursor