Home Forums SQL Server 2005 SQL Server 2005 Strategies How implement object orientation features in sql server? RE: How implement object orientation features in sql server?

  • December 27, 2012 at 10:08 am

    #1571930

    tz.bahrami (12/27/2012)

    How about polymorphism in sql? Could we use stored procedures for polymorphism?

    And for nested relationships can we define an attribute as OId and use it in a select query to point to the table that we want use it in our nested relationship?

    Once again... SQL Server is not an object database. T-SQL is not an object orientated language.

    While you may be able to force some OO-like features into a DB, you're very likely going to end up with a poor design and a badly performing database as a result. Keep the OO in the front end, where your language is OO and not in the database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass