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

Catch this!

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

COUNT, COALESCE, ISNULL, DISTINCT

By Steve Jacobs 2013/11/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,593 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,949 reads

Expressions

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

Handling NULL

By Kapil Singh 2013/04/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,156 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,969 reads

How long is a NULL?

By Arto Ahlstedt 2009/12/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,016 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)