Hi
declare @myfeature varchar(max) = '{"fieldterminator":",","rowterminator":"\n"}',@FeaturesForScript varchar(max)=''
set @FeaturesForScript += isnull(', FIELDTERMINATOR = ''' + JSON_VALUE(@myfeature,'$.fieldterminator') + '''','')
set @FeaturesForScript += ISNULL(',ROWTERMINATOR = ''' + JSON_VALUE(@myfeature,'$.rowterminator') + '''','')
select @FeaturesForScript
when I use "\n" the Json_Value can not get that character and this is empty
result show for me
, FIELDTERMINATOR = ',',ROWTERMINATOR = ' '
Is this Ok?