SET Option Settings.

• Bob-295954

  SSC Rookie

  Points: 39

  More actions

  February 27, 2006 at 4:13 am

  #167771

  Hello.

  In a program I manage, I connect to SQL Server 2000. This program runs queries, thus some SET Options must have some precise values.

  On the MSDN site (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_1ng3.asp), I found the values that need to be given to those options.

  Now, my problem is I can't find one of them : CONCAT_NULL_YIELDS_NULL. Any idea how to turn it on ?

   

  Thanks in advance.

• Loner

  SSC-Insane

  Points: 21279

  More actions

  February 27, 2006 at 8:17 am

  #623471

  This comes from book on line.

  SET CONCAT_NULL_YIELDS_NULL ON

   

• Bob-295954

  SSC Rookie

  Points: 39

  More actions

  March 1, 2006 at 2:30 am

  #623882

  Thanks, but I found the answer in the meantime.

  SET CONCAT_NULL_YIELDS_NULL_ON wasn't working by itself (first thing