|
Posted by Greg Low [MVP] on 10/01/62 11:38
In addition to what ZeldorBlat said, if you need to make larger values, keep
in mind that the + operator is used to concatenate binary strings.
eg: 0xA34B + 0xCA02 is 0xA34BCA02
This can help break such strings up over multiple lines in a script.
HTH,
Greg
"Water Cooler v2" <wtr_clr@yahoo.com> wrote in message
news:1138493601.782824.249580@o13g2000cwo.googlegroups.com...
> There are two datatypes for storing binary data type in the SQL Server:
>
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
>
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
>
Navigation:
[Reply to this message]
|