How to achieve tree structure in MSSQL
I have two tables as follows. I need a hierarchical structure
Test
category                        id

I have a table and each row is a company - the name of the company,
the website, etc. What I would like is one of the entries to be a list
of products that the company sells - and here's the important part - I
want the list of items to be set up so that each item can have its own

I get pages of error logs with this message -
"Got an error reading communication packets". And the aborted clients
are easily in hundreds.
Here is my set of configurations:

I'm looking for two books:
Oracle8i DBA Handbook Kevin Loney, Marlene Theriault
Oracle9i DBA Handbook Kevin Loney, Marlene Theriault
Could anybody send me one of these books?

I am looking for a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks a lot!

is there any dbms (relational) which is available for free & for
windows/linux. my other constraints is that the dbms should support
sql-99 & it should fit on 1 cd. i know about oracle 9i windows
personal edition but it takes 3 cds. how about mysqlplus, db2 & sql

I have a clients table which consists of, among other things, a column
named source.
I have a second table, sources, with two columns - client_id and source.
The are fewer rows in sources than in clients. I am trying to update

I am interested in informed feedback on the use of Constraints, Primary Keys
and Unique.
The following SQL statement creates a Bands tables for a database of
bookings Bands into Venues, where the rule of the business is that only band

1.What advantages does SQL have over relational algebra?
2.How would you compare the division command in SQL and
relational algebra?
3.How would you do division in SQL

Say I have a table with three columns - description, parent_id, and
id.  Each parent_id can, itself, point to another id with a
parent_id.  It doesn't have to, but it can.  If it doesn't, parent_id
will be null.

Suppose I want a column in my table to reference two other columns of
other two tables (of course datatypes are same, and the other two
columns are primary key in their respective relations). How can I
enforce this using SQL?

Help!
I am trying to write an SQL statement (without much luck) to extract
the total number of searches and orders from a particular customer,
grouped into days/months/weeks (depending on the report type.

I am planning to work on a semantic web project (with Jena) using a database
as backend.
Appreciate your tips on which of these is the best for the required task :
Postgre

Due to environment constraints, I have to be able to connect to the local
mysql port (3306) via the hostname "localhost". However, using "localhost"
makes mysql use sockets. This breaks because I don't have a local mysql
server running, hence no socket. I can't seem to find any ...

I'm making a small training program, and I have various exercises such
as:
biking, strength training etc. Some of the fields for these different
activities