Table design with NULL in column

Question

Post reply

Table design with NULL in column

H-122523

Hall of Fame

Points: 3667
More actions
June 15, 2005 at 5:33 am

#164937

Hello all,
I have this design:
ID int IDENTITY PRIMARY KEY
Nr int
In the Nr-column I want unique identity numbers, OR NULL-values. How do I need to configure this column to get this done? Putting an index on this column is not enough, as it will not allow me to enter more than one row in which the Nr equals NULL.
tia

Hans

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

Check out this link for more info on this:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=157147#bm157159

H-122523 Hall of Fame Points: 3667 More actions · Answer 2

Thank you Old Hand,

the VIEW solution will do just fine; any drawbacks known with this solution (performance or otherwise)?

Hans

Phil Parkin SSC Guru Points: 247158 More actions · Answer 3

I've never used this solution - though I see no reason for any drawbacks - except, perhaps, for the ugly message that could be sent back to client apps - non-technical users might not understand what's happened.

Regards

Phil

H-122523 Hall of Fame Points: 3667 More actions · Answer 4

Ok Phil,

thanks again, I'm definitly going to try the view-solution then.

Admin/Moderator: consider issue closed.

regards,

Hans

Table design with NULL in column

Cookies on SQLServerCentral