Ars Technica

[MySQL] Recursive Stored Procedures and their Cursors (oh my)

I have a table that's something like this:<BR><BR><pre class="ip-ubbcode-code-pre">CREATE TABLE thread(id INT, parentid INT, sometext TEXT);</pre><BR><BR>The values ...
Ars Technica

Cursors:When to use, when to avoid? (SQL)

Did he give you a reason why they're absolutely bad? I use cursors all the time and the only time I've run into trouble of any sort is when the Cursor is poorly ...
TechRepublic

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...
Simon Fraser University

Reading and Updating Data with the SQL Procedure

In Version 6, the SAS System's SQL procedure enabled you to retrieve and update data from DBMS tables and views. You could read and display DBMS data by specifying a ...