怎么遍历表数据

2012-06-14

如何遍历表数据?SQL codeDECLARE @STR_DetailIdTABLE(DetailId INT,Old BIT)/*新老子单编号表*/有这样一表

如何遍历表数据?

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
[解决办法]
游标！
[解决办法]
游标！