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

Functions as predicates and SARGable queries

By Uwe Ricken 2014/08/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,866 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,708 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 | 6,048 reads

Expressions

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

Handling NULL

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

How long is a NULL?

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