Wednesday, March 28, 2012

parsing Vabinary contnt

Where to find the syntax for parsing varbinary data in SQLserver?
Thanks
BillDefine "parsing".
What kind of data is in this varbinary content? (binary representations of
native text, files of known type...)
ML
http://milambda.blogspot.com/|||I assume that there's a general syntax to read the column's content.
In this case, it's text data.
thanks
Bill
"ML" <ML@.discussions.microsoft.com> wrote in message
news:54909221-5023-4CF2-A5EC-79FAAA07C907@.microsoft.com...
> Define "parsing".
> What kind of data is in this varbinary content? (binary representations of
> native text, files of known type...)
>
> ML
> --
> http://milambda.blogspot.com/|||If you're parsing a delimited string of character values stored as varbinary
,
maybe you should look at this function by Dejan Sarka:
http://solidqualitylearning.com/blo.../10/22/200.aspx
Of course, you'll have to change the datatype of the parameter and maybe
adapt the logic a bit.
ML
http://milambda.blogspot.com/

No comments:

Post a Comment