Last Updated 02 Mar 2020

American National Standards Institute

Category Essay Examples
Essay type Research
Words 268 (1 pages)
Views 134

In every database project, there would always be requirements for the implementation of its data model. For it to work well and test its functionality, a data value might be needed. This data value will assume a value that is unknown. In relational databases, SQL server uses a placeholder called NULL that resembles unknowns. NULL sets parameters so some data modelers can avoid using it. However, just like any other technology, complications would always arise. One of these is an argument whether it’s good to use NULL or not.

NULL is a condition, apart from being unknown (Poolet, 2006). However, along with its many uses are issues supported by some books that suggest minimization of using NULL. There are also a few authors who came to a point of telling to never declare a column NULL. According to them, declaring a column null would mean minor additional overhead on SQL server. Also, you must see to it that you have accounted for the NULL condition in any program that will gain access to the database most especially to those programming languages that would flag null as an error condition.

The issues, however, do not necessarily suggest to avoid the use of NULL. In the first place, NULL values are created for purpose. It expresses an unknown condition that is valid. The American National Standards Institute, the provider of standardization system in USA, is supporting the use of NULL instead of empty strings. Thus, the use of NULL is just a matter of choice. References Poolet, M. A. (2006, May) Designing for Performance: Null or Not Null? SQL Server Magazine, pg. 31

Don't use plagiarized sources. Get Your Custom Essay on

American National Standards Institute

just from $13,9 / page

get custom paper

Remember. This is just a sample.
You can get your custom paper from our expert writers

get custom paper

Cite this page

American National Standards Institute. (2016, Aug 24). Retrieved from

Not Finding What You Need?

Search for essay samples now

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Your Deadline is Too Short?  Let Professional Writer Help You

Get Help From Writers