Is it not good practice to have single column tables when they are useful... and not include an identifier (ID) column. That way, it seems you could...

andrew.perrins@gmail.com

11-16-2005 07:41 AM
--CELKO--

Hi I'm trying to model a student registration system - unsuccessfully. Can somebody tell me what I'm doing wrong (I've only supplied a cut down...

DJW

11-15-2005 03:00 PM
Ed Prochak

Hi, Quick question... In a one to many relationship does the foreign key always reside in the one part of the relationship? Daniel

Daniel J Watkins

11-15-2005 02:03 AM
Lee Fesperman

Stylus Studio 2006 XML Deployment Adapters, high-performance Java components that provide bi-directional, programmatic access to virtually any data...

Stylus Studio

11-14-2005 02:48 PM
Stylus Studio

Stylus Studio has released Stylus Studio 2006 XML Enterprise Edition. You can download a free trial today...

Stylus Studio

11-14-2005 02:41 PM
Stylus Studio

Good day, I'm a software developer who's currently working on a database-centric project (shocking, I know). One of the goals of the project is to...

markric@gmail.com

11-14-2005 10:19 AM
DM Unseen

Hello, I have made a Sql Statement, but it doesn't work. This is the statement: sqlStatementDataGrid = "SELECT * FROM Apparatuur WHERE ApparatuurID...

Zarkill

11-14-2005 06:39 AM
Jarl Hermansson

I really need some help with this....it's a pretty simple thing but I'm stuck none the less.. I have these attributes listed below that need to be...

thenning

11-14-2005 12:22 AM
dawn

kiranhiremath (AT) gmail (DOT) com wrote: No, it's not you who has to change the password, it's the user: He'll be prompted for a new password,...

Dieter Noeth

11-12-2005 02:28 AM
Dieter Noeth

Hi All We have a table in SQL SERVER 2000 which has about 250 million records and this will be growing by 100 million every week. At a time the...

harish

11-10-2005 07:47 AM
denis.gobo@gmail.com

Hi Will there be any performance difference if a primary index is created instead of a unique index or vice-versa in SQL Server 2000. All the...

harish

11-10-2005 05:04 AM
DM Unseen

Noel wrote: Regards Stefan

giuseppe

11-09-2005 07:23 PM
Bill Karwin

Hello Everybody, Is there any database system which could hold 2 to 3 billion consecutive entries? I am familiar with MS Excel and MS Access. Both...

TES

11-09-2005 04:48 PM
Thomas Kellerer

Hi, I am looking for an open source implementation of citeseer's search engine (extractor and crawler). Is there an implementation available?...

Alpa Jain

11-09-2005 01:30 PM
Ed Prochak

Hi guys, I've been scratching my brain over a particular query all day and I'm hoping an SQL guru might be able to show me my error. I have...

dmcconkey@yahoo.com

11-09-2005 01:07 PM
Ed Prochak

A new XQuery tutorial covering the XQuery FLWOR (For, Let, Where, Order By and Return) Expression has been published, covering the following...

Stylus Studio

11-09-2005 12:45 PM
Stylus Studio

I have a new database structure and am trying to append with curren data. The error message I'm getting is due to type conversion failur due to key...

access is almost great

11-09-2005 12:22 PM
Bill Karwin

All greetings. Prompt the catalogue of programs. The program for reservation of data is necessary. Thanks

sergejru

11-08-2005 02:13 PM
Paul

I'm trying to update a database entry (in MySQL 4) with a value from another table and can't really figure out how to do it. Here's the query that I...

yawnmoth

11-08-2005 01:50 PM
--CELKO--

Hi. I'd like to use openoffice as a frontend to my mysql database. This involves setting some value $foo that can be calculated from other columns of...

Kai-Martin

11-08-2005 09:15 AM
Kai-Martin

I'm new to sql and this forum stuff, so please bear with me I am trying to do a query using LIK This query work Query query =...

j_jimerson

11-08-2005 02:09 AM
j_jimerson

Has anyone managed to get mysql running on a Sun SPARC and if so what is the secret? I've tried old releases and new ones, source and binary, 32 and...

Dave

11-07-2005 07:13 PM
Dave

Hi, I just installed mysql 4.0.21 from sources on a Sun. When I try to run mysqladmin to set the root password, it will not let me connect. I've...

Dave

11-07-2005 10:50 AM
Dave

Hey Everyone, Stylus Studio is very excited about the World Wide Web consortium's candidate recommendation of XSLT 2.0 and XML XQuery 1.0 as...

Stylus Studio

11-07-2005 10:26 AM
Stylus Studio

I have a table temp1 with the following data: a b c d 10 11 888 991 10 11 888 992 How do I pivot...

harish

11-05-2005 06:01 PM
--CELKO--

Disclaimer: I am teaching myself databases just because I want to. This is for my own edification, not for a class. The database I'm attempting to...

doogxela

11-05-2005 12:04 AM
John Doherty

I just got started with SOLID DB (www.solidtech.com). I'm using the SA API and I'd like to store my "own" object in the database. Therefore I have a...

manya

11-04-2005 05:30 AM
manya

Hello, I'm using CA-ERWin and I would like to design entity that migrated into more than one phisical table. Someone can help me? Thanks.

gulzan

11-03-2005 01:03 PM
Ed Prochak

I was wondering what the conventional wisdom said about the following scenario: Lets say you have a company that sells cars. It has 1 head office...

andrewp9@magma.ca

11-03-2005 12:36 PM
Ed Prochak

Is anyone writing applications using two-valued logic (no SQL three-valued logic, for example) and non-first-normal-form in the GUI, the database...

dawn

11-03-2005 12:17 PM
Ed Prochak

Hi, what is the logic behind a checkbook database and how does on build one Should one have a table for deposits, payments. How does one keep...

fperezl

11-01-2005 07:27 AM
Ed Prochak

In terms of database which of the three is best ? Filemaker, Microsof SQL, Access Could someone tell me the advantages of one over the other How...

fperezl

11-01-2005 02:09 AM
kevin

Any experience here with handbase and filemaker How good does the conduit work ? I tried using filemaker 7 mobile an was really dissapointed because...

fperezl

11-01-2005 02:09 AM
fperezl

Hello, it is possible to search a field in a middle of another field of another table? I try something like: SELECT * FROM TABLE1, TABLE2 WHERE...

tony

10-31-2005 03:21 PM
Stefan Rybacki

i've apparently hit a brick wall in my understanding of table relationships. Say I have the following: widgets: id ...

datapanix@gmail.com

10-31-2005 12:43 PM
Ed Prochak

Hi there, My company is about to grow substantially and so will our database. Currently, we obtain vessel data from our clients i.e. speed,...

William Lane

10-31-2005 12:04 PM
Ed Prochak

Hello I'm working on a project with an excel database and need help with the following. This database has some dates that are changed regularly and...

Starriol

10-31-2005 11:42 AM
Starriol

I'm not sure if this topic goes here but, I'm looking for a c++ library that can read a file and use that file as a database. For instance, the...

twoeyedhuman1111@gmail.com

10-31-2005 01:17 AM
Bob Hairgrove

Hi all, I'm puzzling to get some values from the following tables, 'historie' and 'zonegroepcomb_historie' .The two tables contains modified data...

Danny

10-29-2005 09:37 AM
Danny

It was always mentioned that it might take longer to optimize a complex query than actually run the query itself. For complex query optimization, the...

%NAME%

10-28-2005 06:55 PM
--CELKO--

Hi, all! Here's my situation.I have about 10 tables, which contain order numbers. Those numbers are not unique inside tables. My task is to...

andris_sh@yahoo.com

10-28-2005 06:49 PM
--CELKO--

XML Master Series - XML 2005 - November 14-18 - Hilton Hotel - Atlanta, GA IDEAlliance in its continued efforts to provide groundbreaking services to...

melledge

10-28-2005 03:45 PM
melledge

Hi. I want to do a SELECT COUNT(*) for some SELECT-Statements created in other parts of an application and I don't know exactly what that elsewhere...

Stefan Nobis

10-28-2005 09:18 AM
Bill Karwin

What tasks should a database administrator do to maintain a database well?

Gareth

10-26-2005 07:16 PM
DA Morgan

Has a new version of MySQL been developed that does a better job of linking non-MS C programs? I recall that I stopped using the product because it...

Scott J. McCaughrin

10-26-2005 09:03 AM
Paul

Is it a real RDBMS now? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ (Ubuntu) Linux 2.6.13 ^ ^ 19:37:01 up 11 days...

man-wai chang

10-26-2005 06:38 AM
man-wai chang

I am new to MySQL and am trying to develop a windows application with C/C++ to access MySQL database to execute some queries using ODBC. I have...

Jerry

10-25-2005 03:49 PM
denis.gobo@gmail.com

Some customer experienced scalabillity problems with their setup. They were using MySQL and were using multiple MySQL servers, each with their own...

BigPilot

10-25-2005 07:40 AM
Christopher Browne

The Reliable Source for Everything XML - XML 2005 Update XML 2005 - November 14-18 - Atlanta Hilton Hotel - Atlanta,...

melledge

10-24-2005 12:26 PM
melledge

Hi! I'm looking for program - something like old dos FoxPro 2.* or dBase I have two tables in two dbf files. I wont to connect to them and make...

Orb

10-24-2005 06:57 AM
N. Shamsundar