Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag NULL Rss

   Items 1 to 20 of 24    Older >>
 

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,305 reads

integer lengths (II)

By Tom Thomson 2015/07/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,790 reads

CHECK Constraints vs NULL values

By Justin Clementz 2015/05/01 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,652 reads

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count
Rating: (not yet rated) |  Discuss |   Briefcase | 2,208 reads

Find Null values on every column

with this script you will be able to see if you have a null value on every column of your table  Read more...
By Leonardo Campos 2015/01/28 | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 1,911 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: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 12,084 reads

What is (Null='Hello') in Sql Server

By Jaime PadrĂ³n 2014/03/27 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 2,303 reads

T-SQL counts

By Samith C 2013/10/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,794 reads

BETWEEN a hard place and a rock

By Hugo Kornelis 2013/06/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,703 reads

Usage of Null

By Bhavpreet Singh Narang 2013/06/05 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 2,377 reads

Data Type

By Yogesh Kumar 2013/05/10 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 2,191 reads

Basic of T-SQL

By Naseer Ahmad 2012/08/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,447 reads

NULL

By Samith C 2012/08/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,972 reads

NULLS

By Robin Sasson 2012/05/11 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 3,296 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: MSSQLTips.com | Category: bit columns
Rating: (not yet rated)  Rate this |   Briefcase | 3,834 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: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 6,631 reads

Tables

By SQL Buzz 2010/06/17 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 3,905 reads

ANSI_NULLS

By Paul White 2010/04/07 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 4,007 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: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,022 reads

How long is a NULL?

By Arto Ahlstedt 2009/12/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,029 reads
   Items 1 to 20 of 24    Older >>
 
Tags
t-sql (19)    
count (3)    
aggregates (2)    
database design (2)    
ansi_nulls (1)    
bit columns (1)    
blogs (1)    
cast and convert (1)    
check constraints (1)    
constraints (1)    
datatypes (1)    
except (1)    
group by (1)    
implicit conversion (1)    
isnull (1)    
not null (1)    
str (1)    
strings (1)    
xml (1)