如何遍历表数据?

SQL code

DECLARE @STR_DetailId    TABLE(DetailId INT,Old BIT)    /*新老子单编号表*/

有这样一表变量,并且往里插入了一些数据,如果遍历它呀?

[解决办法]
遍历它呀?

游一行行取值，不值直接取

[解决办法]
循环.....
[解决办法]

SQL code

DECLARE Employee_Cursor CURSOR FORSELECT EmployeeID, Title FROM AdventureWorks.HumanResources.Employee;OPEN Employee_Cursor;FETCH NEXT FROM Employee_Cursor;WHILE @@FETCH_STATUS = 0   BEGIN      FETCH NEXT FROM Employee_Cursor;   END;CLOSE Employee_Cursor;DEALLOCATE Employee_Cursor;GO
[解决办法]
游标！
[解决办法]
游标！