Let's assume you're loading data into a table using BULK INSERT from tab
separated file. Among others you have some varchar field, which may contain any
character. Content of such field is escaped with usual scheme:
But now, after loading, you want to unescape content back. How would you do it?
'\' + char(9)
It might be that you're smart and you will immediately think of correct
algorithm, but for us it took a while to come up with a neat solution:
declare @value varchar(max);
set @value = ...
-- This unescapes the value
set @value =
replace(@value, '\\', '\ '),
Do you know a better way?
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u