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

Content with tags T-SQL, ISNULL Rss

   Items 1 to 8 of 8   
 

Functions as predicates and SARGable queries

By Uwe Ricken 2014/08/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,676 reads

Catch this!

By Auke Teeninga 2014/04/10 | Category: isnull
Rating: (not yet rated) |  Discuss |   Briefcase | 2,059 reads

COUNT, COALESCE, ISNULL, DISTINCT

By Steve Jacobs 2013/11/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,566 reads

How are COALESCE and ISNULL different?

At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...  Read more...
By Kenneth Fisher 2013/08/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,800 reads

Expressions

By Leigh Waldie 2013/08/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,200 reads

Handling NULL

By Kapil Singh 2013/04/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,144 reads

Twist in ISNULL function

Be careful while using the ISNULL function  Read more...
By Ashutosh Pandey 2012/02/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,962 reads

How long is a NULL?

By Arto Ahlstedt 2009/12/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,011 reads
   Items 1 to 8 of 8   
 
Tags
coalesce (2)    
blogs (1)    
count (1)    
distinct (1)    
error handling (1)    
null (1)    
nullif (1)    
sargable (1)    
try..catch (1)