Forum Replies Created

Viewing 15 posts - 391 through 405 (of 431 total)

  • RE: Avoiding a circular relationship in table design

    Use two tables for hardware, one for each of the two sub-types. I'm not clear whether you actually need DistributorID in these tables. Isn't that implied by the Owner or...

  • RE: SQL or Oracle

    All I am saying is that the SQL data model (the model of tables, views and DML) is not relational, which is what relational experts like Codd, Date, Darwen and...

  • RE: SQL or Oracle

    Please tell me the exact mathematical difference between a "tuple bag" and a "relation" or "set". Prove your answer using standard mathematical methodology and terminology, please.

    Start here:

    http://www-users.cs.york.ac.uk/~susan/cyc/b/bag.htm

    Now let R...

  • RE: SQL or Oracle

    Gift Peddie (2/5/2009)


    I looked at the docs at Rel's page and checked the D section in Thethirdmanifesto home page and I see a lot of differences.

    I guess you are talking...

  • RE: SQL or Oracle

    Gift Peddie (2/5/2009)


    (Chris Date, and others, have done a uniform language which can handle network data model, hierarchical data model, relational data model.)

    So the link David posted is also not...

  • RE: SQL or Oracle

    GSquared (2/5/2009)


    The Berkley DB (which is what Rel is based on) is not relational. It stores data as key-value pairs without relations. Yes, Rel may be "relational", but...

  • RE: SQL or Oracle

    Michael Earl (2/5/2009)This is all symantics and you really do your arguments a dis-service by going in this direction with your discussion. It's the programming version of name-calling.

    It's a...

  • RE: SQL or Oracle

    Gift Peddie (2/5/2009)The most important it comes without the third part of the relational model DCL(data control language.)

    Not sure what you are getting at there. DCL has nothing to do...

  • RE: SQL or Oracle

    Max (2/5/2009)


    Gift Peddie (1/18/2009)


    ...Access and VFP are things Microsoft sells as database both are not relational.

    Heh? Access is relational.

    No Microsoft Access is an application development tool.

    Jet/ACE is a software component...

  • RE: SQL or Oracle

    GSquared (1/30/2009)


    If you're building an application that might sit on top of many types of database servers, that's one thing. If you're building an internal application that employees use,...

  • RE: SQL or Oracle

    Loner (1/27/2009)


    Oracle uses cursor extensively and SQL Server is a 'no, no'. The SQL Server DBA threw back my first SQL Server stored procedure to me and yelled at me...

  • RE: SQL or Oracle

    Gift Peddie (1/18/2009)


    Access and VFP are things Microsoft sells as database both are not relational.

    SQL Server isn't relational either but more to the point Access and VFP are application development...

  • RE: Using semi-colon in t-sql

    This is a bit of a mess. In SQL Server 2000 semicolons were optional or in a few cases actually not allowed at the end of statements. In 2005/2008 they...

  • RE: Help with design of Database for complete novice

    I don't want to discourage you from learning - far from it - but have you considered getting some professional assistance with this system?

    It seems a bit alarming that someone...

  • RE: Common Mistakes in T-SQL

    hbpank (12/30/2008)


    what are the Common Mistakes in T-SQL ?

    For example: @@Error gives correct value in next line only. after that it Value gets Reset.

    Do we have any compilation...

Viewing 15 posts - 391 through 405 (of 431 total)