If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic’s ...

I'm having an issue with an ASP page occasionally timing out. The specific error is the following:<BR><BR>"*.DBCommand.Execute(): Microsoft OLE DB Provider for SQL ...

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...

Developers often dismiss dynamic SQL used in PL/SQL programs for two reasons. One reason is that it's riskier because the SQL statements aren't parsed until runtime, so it's more difficult to catch ...