Writing Efficient SQL: Set-Based Speed Phreakery Posted by Ramani Sandeep on February 8, 2010
SQL is a declarative language, designed to work with sets of data. However, it does support procedural, "row-by-row" constructs in the form of explicit cursors, loops and so on. The use of such constructs often offers the most intuitive route to the desired SQL solution, especially for those with backgrounds as application developers. Unfortunately, th...
No comments yet, be the first one to post comment.