Unknown NULLs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mike Molnar » Unknown NULLs

21 posts, Page 3 of 3

«««1 2 3

Unknown NULLs

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Friday, March 23, 2012 5:03 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:53 PM
Points: 7,179, Visits: 7,276

Kevin Gill (10/28/2009)

My example was just a simplified version where you might be comparing foreign keys which map to identity columns and thus can never validly be negative.

Identity columns can easy be negative. Create them with a negative seed, or with a negative increment, or both is one way. setting identity insert on and placing explicit negative values is another. They are quite common when a large range is needed (bigger than 2 billion) - an identity column starting with seed 2**-31 and increment +1 gives the maximum possible range of values.

Saying 'it isn't something you should use' seems a little black and white when it's perfectly valid in many situations...

OK, maybe it should have been "it isn't something you should use unless you are absolutely certain you can pick a null-replacement value that is guaranteed to be safe". But remember that Murphy's law applies, so that most people will sometimes choose an "absolutely guaranteed safe" value that isn't safe at all.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

http://es.linkedin.com/in/tomthomsonsoftware

Post #1272174

« Prev Topic | Next Topic »

21 posts, Page 3 of 3

«««1 2 3

Permissions