DECLARE curEmp CURSOR FOR SELECT EmpID FROM Employee
OPEN curEmp
FETCH NEXT FROM curEmp INTO @EmpID
WHILE(@@FETCH_STATUS = 0)
BEGIN
-----
-----
-----
END
CLOSE curEmp
DEALLOCATE curEmp
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment