Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

SET CONCAT_NULL_YIELDS_NULL OFF


I'm trying to get a 6.5 database to work properly in sql 2000. There's an SP
which concatenates (sometimes) null values with another string. As SQL 2000
handles this proc differently I've added SET CONCAT_NULL_YIELDS_NULL OFF to
the sp and it works correctly.

An article on MSDN notes that this feature will be removed in future SQL
versions and suggests modifying apps that use this feature. My question is:
What are the alternatives?

Instead of:
[field a] + [field with nulls]

Use:
[field a] + coalesce([field with nulls], 'an empty string')

Coalesce returns the first nonnull expression among its arguments.

Cheers,
Jason Lepack
On May 1, 4:47 pm, "Rod" <evans.rodnos@gmail.com> wrote:

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc