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

Determine when to use stored procedures vs. SQL in the code

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...
Visual Studio Magazine

Speed Up Stored Procedures with Table Valued Parameters

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...