I am looking for a way to run SQL-Server with Windows XP. I am trying to
do this, so I can practice database design on my home PC. My first
information was that SQL-Server was written for WinNT and so on only.
Could someone shed some light on this matter?

Could someone give me an example of a union query using name, title and
salary?
(Access)
--

I was wondering if any of you guys out there have
got any example databases that I could have, with an ERD diagram the company
scenario & table design.
I'm a second year computer science student and have to make a database for a

I have a table 'members' with these rows: 'id' , 'name'
I have about 20000 records in this table
I have a table 'members_info' with these rows: 'member_id' , 'info1',
'info2', ...

I have downloaded both CPAN-moduls DBD-Oracle-1.14.tar and
DBI-1.39.tar.
But I fail in installing these moduls! The Perl Package Manager (PPM)
returns this error message:

I'm trying to build a familytree with mysql and have a table with info
about every person. But how do I do with children, a person can have
many so I would have to create a relationship (as in MS Access) but as
Ive understood it you cant do that with mysql. How do I go about to ...

Hi again,
I read http://fungus.teststation.com/~jon/treehandling/TreeHandling.htm
and have following questions:
1) where not exists (

I'm looking into how databases work.
1) Is it possible for DBMS's to schedule disk IO such that if 3
transactions are running concurrently, it sorts the accessess by how
near they are to eachother (to reduce the number of seeks).

table 1
APP_ID
1   
3   

I want to learn how to use SQL.  So I want to know the best way to
download a SQL program so I can create my own server and try to put
things in the database and do queries and other things.  I downloaded
mySQL and I realy didn't understand how to set up the database server

We're doing ad hoc reporting from data currently being stored rather
mindlessly in Oracle. An interesting software tool records our access
patterns of tables and actually draws ERT diagrams of our ad hoc
reporting. The tool vendor says the tool helps us design a "reporting

i am currently in the process of building a website that is going to
contain a member base(or so i hope).  I don't know much about building
your own website but am teaching myself html, java, flash and
dreamweaver. Am starting to become more proficient but i need to

As I open "driver" for ODBC, there is something called "Microsoft Text
Driver (*.txt; *.csv)"
Ok, I understand that a .csv is, but I don't understand how ODBC will run
SQL on a .csv.

I'm starting to work with mysql (but I think my post applies to other
databases as well) and I've come across a problem - I've read in several
sources that the order of retrieved rows by a SELECT statement is
undefined unless you use GROUP BY or ORDER BY. Now I need to be able to ...

am trying to compile a C program calling MySQL functions. I have pointed to the directory containing the header files, and to the directory containing the client library. I get a linker message saying the linker can't find mysql_query, mysql_fetch_row, and all the other mysql ...