var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sp_option... 'concat null yields null'
I'm trying to set the concat... option to OFF
all the time and in all my databases
I tried this command
EXEC sp_dboption 'DatabaseName', 'concat null yields null', 'FALSE'
but it doesn't change anything
Select NULL + 'TOTO'
(it should be 'TOTO')
Any way you can pepper your code with isnull()'s?
select isnull(null, '') + 'toto'
but it's a migration pb
all queries were written for SYBASE
and I have to re-check all queries for possible NULL concatenation