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

Content with tag ISNULL Rss

   Items 1 to 11 of 11   
 

Catch this!

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

COUNT, COALESCE, ISNULL, DISTINCT

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

Expressions

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

Handling NULL

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

Deciding between COALESCE and ISNULL in SQL Server

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in order to provide a default value in cases where the input is NULL. The two functions do have quite different behavior and it is important to understand the qualitative differences between them when using them in your code.  Read more...
By Additional Articles 2012/05/08 | Source: MSSQLTips.com
Rating:  Rate this |   Briefcase | 9,288 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,936 reads

An interesting thing about isnull

By Richard Maw 2010/03/31 | Category: isnull
Rating: (not yet rated) |  Discuss |   Briefcase | 4,315 reads

How long is a NULL?

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

ISNULL

By Marius Els 2009/11/03 | Category: isnull
Rating: (not yet rated) |  Discuss |   Briefcase | 4,442 reads

Create string from table

This simple script retrieves a range of values from a table and presents the results as a string.  Read more...
By Swashbuckler 2008/09/15 | Source: SQLServerCentral.com | Category: coalesce
Rating: |  Discuss |   Briefcase | 1,533 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (7)    
coalesce (4)    
blogs (1)    
builtin functions (1)    
concat (t-sql) (1)    
count (1)    
distinct (1)    
error handling (1)    
null (1)    
nullif (1)    
string manipulation (1)    
try..catch (1)