Should I Use GUID or IDENTITY as Thread Number?

Posted by user311509 on Stack Overflow See other posts from Stack Overflow or by user311509
Published on 2010-12-31T23:46:25Z Indexed on 2010/12/31 23:54 UTC
Read the original article Hit count: 186

Filed under:
|
|
|

offerID is the thread # which represents the thread posted. I see in forums posts are represented by random numbers. Is this achieved by IDENTITY? If not, please advice.

nvarchar(max) will carry all kind of texts along with HTML tags.

CREATE TABLE Offer
(
    offerID           int IDENTITY (4382,15) PRIMARY KEY,
    memberID          int NOT NULL REFERENCES Member(memberID),
    title             nvarchar(200) NOT NULL,
    thread            nvarchar(max) NOT NULL,
        .
        .
        .
);

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about database