Viewing 15 posts - 346 through 360 (of 432 total)
GSquared (11/18/2009)
November 18, 2009 at 1:45 pm
Your SQL solution does not solve the problem because it is still possible to create an order in the Orders table without any corresponding Order_Item.
You suggested using a trigger but...
November 18, 2009 at 1:43 pm
Lynn Pettis (11/18/2009)
David Portas (11/18/2009)
... They include Dataphor, Muldis and various other open source efforts.
Interesting that you mention Dataphor. There have been others that have been religous zealots...
November 18, 2009 at 1:13 pm
All my replies were intended in a positive and constructive spirit of contribution. I hope we can keep it that way. But as I said, I really didn't want to...
November 18, 2009 at 11:20 am
GSquared (11/18/2009)
Interesting problem, but easily solved by adding a foreign key constraint to the Orders table, referencing the OrdersItems table (a join table between Orders and Items).
Then how would you...
November 18, 2009 at 9:08 am
I didn't want this to become a discussion about nulls because if you fix the other issues (such as providing decent type support and a truly relational language) then the...
November 18, 2009 at 8:25 am
Elliott W (11/17/2009)
So in my view the three things you mention are already handled, could they be better, sure, but that doesn't support your position..
Oh dear! I wasn't very clear...
November 17, 2009 at 9:32 pm
Elliott W (11/17/2009)
SQL isn't broken, but that isn't to say that it solves EVERY need. What I see most is tweaks to existing features.
I don't think tweaking or enhancing...
November 17, 2009 at 3:33 pm
GSquared (11/17/2009)
November 17, 2009 at 2:26 pm
I agree with the comments so far. However, I do wonder if we database professionals working with SQL are collectively partly to blame for the lack of momentum and new...
November 17, 2009 at 1:29 pm
Jeff Moden (11/7/2009)
David Portas (11/7/2009)
In either SQL or Oracle you can use COALESCE, which is the Standard SQL function instead of ISNULL and NVL which are non-standard.
Why do you think...
November 8, 2009 at 4:19 am
In either SQL or Oracle you can use COALESCE, which is the Standard SQL function instead of ISNULL and NVL which are non-standard.
November 7, 2009 at 10:40 am
Whatever you choose for a naming convention the most important thing is to be consistent about using it. Perhaps the intention in your case was to distinguish the name of...
October 20, 2009 at 1:27 pm
Do you have to insert duplicates though - even though you can't declare a key?
Basically the design is unusable - you can insert rows to it but you can never...
October 12, 2009 at 3:08 pm
cy-513176 (10/9/2009)
the codes will not be unique...bummer.
Why not? What's the point of filling up a table with duplicate codes with different IDENTITY values? That goes against the very point of...
October 11, 2009 at 10:55 am
Viewing 15 posts - 346 through 360 (of 432 total)