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

Content with tags T-SQL, NULL Rss

   Items 1 to 20 of 21    Older >>
 

Getting rid of NULL

By Steve Jones 2017/01/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,616 reads

Equality on Nullable Columns

By Mayank Shukla 2016/02/17 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,642 reads

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

integer lengths (II)

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

CHECK Constraints vs NULL values

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

Group By, Count, and NULLs

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

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

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

T-SQL counts

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

BETWEEN a hard place and a rock

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

Usage of Null

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

Data Type

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

Basic of T-SQL

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

NULL

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

NULLS

By Robin Sasson 2012/05/11 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 3,324 reads

Tables

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

ANSI_NULLS

By Paul White 2010/04/07 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 4,021 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,137 reads

How long is a NULL?

By Arto Ahlstedt 2009/12/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,046 reads

More Fun With NULL

By John Arnott 2009/11/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,699 reads

Varchar division

By John Deupree 2009/09/14 | Category: implicit conversion
Rating: (not yet rated) |  Discuss |   Briefcase | 4,115 reads
   Items 1 to 20 of 21    Older >>
 
Tags
count() (3)    
aggregates (2)    
ansi_nulls (1)    
blogs (1)    
cast and convert (1)    
check constraints (1)    
constraints (1)    
datatypes (1)    
except (1)    
group by (1)    
implicit conversion (1)    
isnull (1)    
str (1)    
strings (1)