Computerworld

Brug af cursor i Stored Procedure

Jeg har lavet en stored procedure som desværre returnerer TO resultset. Jeg kan så ikke hive dataene frem i C#. Det skyldes brug af cursor. Min sql er lidt lang og sat på til allersidst. Her kommer ...
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 ...
Computerworld

Stored Procedure returnerer forkert select (cursor)

LEFT JOIN dan_FreightProduct fp on k.F_FreightProductID = fp.FreightProductID Jeg regnede med jeg blot skulle skrive RETURN på det jeg ville returnere, men jeg for en forkert værdi. Jeg håber på hjælp ...
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 ...