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

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
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.
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

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