FETCH NEXT FROM Role_TOTAL_cursor
INTO @ProjectManageNo, @EmployeeNo, @RoleName少了这句话DECLARE Employee_Cursor CURSOR FOR
SELECT LastName, FirstName FROM Northwind.dbo.Employees
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
INTO @ProjectManageNo, @EmployeeNo, @RoleName少了这句话DECLARE Employee_Cursor CURSOR FOR
SELECT LastName, FirstName FROM Northwind.dbo.Employees
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
INTO @ProjectManageNo, @EmployeeNo, @RoleName
INTO @ProjectManageNo, @EmployeeNo, @RoleName
在游标循环中也应该有这一句