Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag NULL Rss

Search for any content tagged null

   Items 1 to 6 of 6   

How to Get NULLs Horribly Wrong in SQL Server

NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.  Read more...
By Additional Articles 2015/07/14 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,488 reads

Database Design Follies: NULL vs. NOT NULL

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.  Read more...
By Edward Pollack 2014/10/30 | Source: | Category: null
Rating: |  Discuss |   Briefcase | 12,172 reads

Using bit columns with NULLs when three options exist in SQL Server

Frequently surveys ask yes/no questions and use a bit datatype. What are the effects of allowing this column to be NULL in a SQL Server table? Check out this tip to learn more.  Read more...
By Additional Articles 2012/01/05 | Source: | Category: bit columns
Rating: (not yet rated)  Rate this |   Briefcase | 3,930 reads

Working with null values in SQL XML

We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?  Read more...
By Richard Rozema 2010/10/26 | Source: | Category: null
Rating: |  Discuss |   Briefcase | 6,684 reads

Concatenating Strings to NULL values

We recently ran into this situation of reports containing nothing but blank spaces. When investigated the reason was that the String...  Read more...
By Bru Medishetty 2010/02/01 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,067 reads

Accommodating Null Values in SQL Server

The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.   Read more...
By Additional Articles 2009/09/16 | Source: DevX | Category: null
Rating:  Rate this |   Briefcase | 4,064 reads
   Items 1 to 6 of 6