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

Content with tags T-SQL, ISNULL Rss

   Items 1 to 9 of 9   
 

IsNull and Coalesce

By Mayank Shukla 2016/02/29 | Category: data type
Rating: (not yet rated) |  Discuss |   Briefcase | 1,528 reads

Functions as predicates and SARGable queries

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

Catch this!

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

COUNT, COALESCE, ISNULL, DISTINCT

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

Expressions

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

Handling NULL

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

How long is a NULL?

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