select 字段1,字段2 from table fetch net from cur_tempDate into 变量1,变量2
CREATE TABLE tb(col1 varchar(10),col2 int) INSERT tb SELECT 'a',1 UNION ALL SELECT 'a',2 UNION ALL SELECT 'b',1 UNION ALL SELECT 'b',2 UNION ALL SELECT 'b',3declare Teacher_Cursor_list cursor for select col1,col2 from tb order by col1 /*游标Teacher_Cursor的创建见上面的例子*/declare @col1_col2 char(255) open Teacher_Cursor_list declare @TNAME_NOW char(255) declare @DNAME_NOW int fetch next from Teacher_Cursor_list into @TNAME_NOW,@DNAME_NOW select @col1_col2=@TNAME_NOW+cast(@DNAME_NOW as varchar(10)) print @col1_col2close Teacher_Cursor_list DEALLOCATE Teacher_Cursor_list select * from tb
declare TTTT cursor for select 字段1,字段2 from table order by 字段1 . . . . fetch net from TTTT into 变量1,变量2
fetch net from cur_tempDate into 变量1,变量2
INSERT tb SELECT 'a',1
UNION ALL SELECT 'a',2
UNION ALL SELECT 'b',1
UNION ALL SELECT 'b',2
UNION ALL SELECT 'b',3declare Teacher_Cursor_list cursor
for
select col1,col2 from tb
order by col1
/*游标Teacher_Cursor的创建见上面的例子*/declare @col1_col2 char(255)
open Teacher_Cursor_list
declare @TNAME_NOW char(255)
declare @DNAME_NOW int
fetch next from Teacher_Cursor_list into @TNAME_NOW,@DNAME_NOW
select @col1_col2=@TNAME_NOW+cast(@DNAME_NOW as varchar(10))
print @col1_col2close Teacher_Cursor_list
DEALLOCATE Teacher_Cursor_list
select * from tb
select 字段1,字段2 from table order by 字段1
.
.
.
.
fetch net from TTTT into 变量1,变量2