Welcome to Sign in | Help

Re: Coloana ntext

  •  04-02-2008, 4:37 PM

    Re: Coloana ntext

    Incearca:

    - tabel Project cu coloanele: ProjectID int (primary key)+ coloanele numerice...

    - tabel ContentType cu coloanele: ContentTypeID int (primary key), ContentType varchar(...) - "Long", "Short", etc...

    - tabel ProjectContent cu coloanele: ProjectContentID int (primary key), ProjectID (foreign key), ContentTypeID (foreign key), Content (ntext). Daca proiectul exista si are "content", inserezi randuri in ProjectContent cu acel ProjectID si ContentTypeID.

    "Content" - ul pentru un proiect:

    SELECT Content FROM ProjectContent WHERE ProjectID = @ProjectID AND ContentTypeID = @ContentTypeID

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems