I need to write a query in SQL that returns specific records, I am not
sure how to approach it.
I was wondering if someone would have any suggestion.
Here is the situation.

I was thinking, is there any open, common standard for database and data
access ?
I have been using proprietary standards until now to access data and
send SQL commands to most database systems but I want to switch to open

In recent thread titled "Generalised Approach to Storing Address
Details" in cdt, the following argument was make against hierarchal
interfaces (not hierarchal data model):
"It has been proven in numerous research studies that menu's use is

Im trying to design a database to hold metadata for video, image and
audio clips.
The current prototype (read quick dirty hack) has two tables:
tblMedia

I have a design question. Is there any reason NOT to allow spaces in a
primary key field? For instance, if the primary key field is called
SampleID and a value in that field can either look like "SAMPLE1" or
"SAMPLE 1", is there any reason to enforce a convention like the former

I have one of our production Accounting Databases starting from 2 GB
now grown into a 20 GB SQL Server 2000 Database over the period of a
few years...
I have been getting timeouts when transactions are trying to update

Anyone have any suggestions for a good, user friendly, db management tool
for SQL server?
Needs to be able to create tables, insert records, modify columns, etc.
Thanks,

I have a MacBook Pro running OS X 10.4 I have apache 2.2 and am running
the most current version of mySQL.
I cannot get DBD::mysql to install.  I have downloaded the perl module
form CPAN and tried both automated and manual installations.  During

Hi I need a simple Library management program for 1 of my assignments.
Ca any 1 help.

I know I'm very behind the times.  I just bought a new HP computer with
Windows XP.  My old computer was a Gateway with Windows 98.  The old
computer let me start up in MSDOS and use dbase.  My new computer does
not have a MSDOS prompt that I know how to get to.  I hate to keep two

I have 3 tables
Person
Period
Calendar

Hey Guys/Gals
Could someone please send me list of all countries and all the cities
which they have? Needed urgently for my school project.

Small (15 folks) engineering company looking to expand and use a DB to
track files, protect: folders, reports, photos, and files from deletion
and being misplaced.  We also want to have a CRM package that will work
with Outlook.  A big bonus would be finding files by a search for ...

I've just strated learning ProSQL, becasuse the system we use, uses it, but
need more information. Can anyone point me in the right direction to where i
can get more information please.
Thanks,

  Does anybody have any literature that compares the performance of
IDMS and DB/2? Specifically, I am looking for CPU usage or MIPS
required to perform like tasks. That is to say, if you had two
functionally identical databases running side by side, which one would