April 8, 2003 at 5:26 am
I can see no effect for:
sp_dboption 'sv', 'concat null yields null', 'off'
For both on and off the result is the same.
I tested with:
select 'x' + NULL
The result is always NULL.
sp_dboption 'sv' does show that the option is there after 'on' and is gone after 'off', but it does not show in the results of the select.
I also tried:
alter database sv set CONCAT_NULL_YIELDS_NULL off with no_wait
This has no effect either.
I see this with MSSQL 2000 SP 3 and MSSQL 7 SP4.
SET CONCAT_NULL_YIELDS_NULL OFF
and
SET CONCAT_NULL_YIELDS_NULL ON
do work.
Does anybody know why this does not work?
Joachim.
April 8, 2003 at 5:40 am
Never used it enough to set at the db level. Looks like there has been some discussion:
Andy
April 8, 2003 at 6:09 am
Keep in mind if using QA that it has a set of connection options set of which concat null is on. Look at Tools/Options and the Connection Properties tab for more.
April 8, 2003 at 6:23 am
That is it. I can now control it in isqlw with the connection properties and in ODBC with 'Use ANSI nulls, paddings and warnings".
Thank you.
Joachim.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy