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
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