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 7 of 7   
 

Handling NULL

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

An interesting thing about isnull

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

How long is a NULL?

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

ISNULL

By Marius Els 2009/11/03 | Category: isnull
Rating: (not yet rated) |  Discuss |   Briefcase | 4,415 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,504 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (3)    
coalesce (2)    
builtin functions (1)    
concatenate (1)    
null (1)    
string manipulation (1)