Missed the part that states:
The following table lists the acceptable data types for the value argument together with their .NET Framework mapping equivalent types.
They are serious about this. Tried the bit data type and it failed miserably.
So you still have to do a
convert([n]varchar(1), @bit_value)
for the value as number or case when @bit_value = 1 then 'TRUE' when @bit_value = 0 then 'FALSE' else 'NULL' end
for the value as text.
No comments:
Post a Comment