如何遍历表数据?

Question

DECLARE @STR_DetailId TABLE(DetailId INT,Old BIT) /*新老子单编号表*/有这样一表变量,并且往里插入了一些数据,如果遍历它呀?

Answer 1

DECLARE Employee_Cursor CURSOR FOR
SELECT 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