columns After Merge:
jon B1 jad
Null Null als A2
please help !!
SELECT ISNULL(A,'')+ISNULL(B,'') as AB,
ISNULL(DA,'')+ISNULL(DB,'') as TD
Select IsNull(A, '') + IsNull(B, '') As AB,
IsNull('DA', '') + IsNull(DB, '') As TD
set A =ISNULL(A,'')+ISNULL(B,'')
, DA =ISNULL(DA,'')+ISNULL(DB,'')
Select A,DA from [table_1]
Please provide your table DDL.
It's difficult to follow with the formatting, but you just want to concatenate the fields??
SELECT A + B, DA + DB FROM MYTABLE;
I'am use : update [table_1] set [my column after merge] = A + B, DA
but , when DA = NULL and DB = A2 /I'am show result TD = NULL !!!!!
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?