SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag NULL Rss

   Items 1 to 20 of 32    Older >>
 

Missing Data

Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.  Read more...
By Additional Articles 2018/07/04 | Source: SimpleTalk | Category: null
Rating: (not yet rated)  Rate this |   Briefcase | 2,318 reads

CHECKSUM() and NULL

By Thomas Franz 2017/11/21 | Category: checksum
Rating: (not yet rated) |  Discuss |   Briefcase | 753 reads

What does NULL equal?

By Alan Burstein 2017/09/11 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,213 reads

Getting rid of NULL

By Steve Jones 2017/01/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,751 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 2016/11/04 | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 2,388 reads

Comparing with NULL

By Thomas Franz 2016/09/26 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,413 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 2016/02/26 (first published: 2014/10/30) | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 17,476 reads

Equality on Nullable Columns

By Mayank Shukla 2016/02/17 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,658 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,756 reads

integer lengths (II)

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

CHECK Constraints vs NULL values

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

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,334 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 2016/11/04 | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 2,388 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 2016/02/26 (first published: 2014/10/30) | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 17,476 reads

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

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

T-SQL counts

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

BETWEEN a hard place and a rock

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

Usage of Null

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

Data Type

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

Basic of T-SQL

By Naseer Ahmad 2012/08/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,512 reads
   Items 1 to 20 of 32    Older >>
 
Tags
t-sql (22)    
count() (3)    
aggregates (2)    
database design (2)    
ansi_nulls (1)    
bit columns (1)    
blogs (1)    
cast and convert (1)    
check constraints (1)    
checksum (1)    
compare (1)    
constraints (1)    
data loss (1)    
datatypes (1)    
except (1)    
group by (1)    
implicit conversions (1)    
isnull (1)    
not null (1)    
str (1)    
strings (1)    
xml (1)