简单问题,如何循环表?
如何一条记录一条记录的去读完整个表
就是游标的功能
但不能用游标去做
用while?怎么写代码?
下面是游标代码:
DECLARE Scheme_cursor CURSOR FOR
SELECT c_Local_Type,c_Long_Type,i_Time
FROM tb_list
ORDER BY dt_Call_Date
Open Scheme_cursor
FETCH NEXT FROM Scheme_cursor
INTO @cLocalT,@cIPType,@iTime
WHILE @@FETCH_STATUS = 0
BEGIN
/*
处理语句
*/
FETCH NEXT FROM Scheme_cursor
INTO @cLocalT,@cIPType,@iTime
END
CLOSE Scheme_cursor
DEALLOCATE Scheme_cursor
即如何用while来代替游标?