The SQL statement: SQLwhile (0=0) and while @@fetch_status=0.

The first sentenceIs the SQL cycle, this condition, reads all the records, because will have been circulating;

The second sentenceThere is a cursor, @@fetch_status=0 equals 0, the cursor is successful.

Posted by Spencer at November 22, 2013 - 7:13 AM