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 ...

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 called Categories.

In my VB.Net application, I need to be able to get the string "Hardware:CPU=Intel:Speed=3 ghz" by querying the database table above. I'm almost positive this can be done using recursive SQL or Common ...

There is no simple way to create recursive queries that have several levels of data (hierarchical data) in SQL Server 2000. A recursive query is used when you have a parent and child data stored in ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...