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 18 of 18   
 

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

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

T-SQL counts

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

BETWEEN a hard place and a rock

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

Usage of Null

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

Data Type

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

Basic of T-SQL

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

NULL

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

NULLS

By Robin Sasson 2012/05/11 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 3,265 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,673 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,456 reads

Tables

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

ANSI_NULLS

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

How long is a NULL?

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

More Fun With NULL

By John Arnott 2009/11/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,662 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 | 3,937 reads

Varchar division

By John Deupree 2009/09/14 | Category: implicit conversion
Rating: (not yet rated) |  Discuss |   Briefcase | 4,092 reads

Unknown NULLs

By Mike Molnar 2009/08/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,652 reads
   Items 1 to 18 of 18   
 
Tags
t-sql (15)    
aggregates (2)    
count (2)    
ansi_nulls (1)    
bit columns (1)    
blogs (1)    
constraints (1)    
data types (1)    
database design (1)    
except (1)    
implicit conversion (1)    
isnull (1)    
strings (1)    
xml (1)