Home Forums SQL Server 2014 Development - SQL Server 2014 Will SQL Server 2014 Support to Read BLOB (Byte Array) RE: Will SQL Server 2014 Support to Read BLOB (Byte Array)

  • December 15, 2013 at 1:08 pm

    #1673557

    yuvipoy (12/15/2013)

    Jeff Moden (12/14/2013)

    yuvipoy (12/14/2013)

    as i said i need to split byte-array based on the size.

    say there are 3 columns in a table.

    i am having the information in the byte array format

    i need to extract those format and insert in to the table.

    for first column 4 bytes second column 2 bytes third 8 bytes.

    What is the ultimate datatype of those 3 columns?

    So what ever it may be it may be Int , float, Bigint

    or even varchar

    String data conversion to a varchar data type in DB

    the bytearray will be having float,smallint,bigint

    or

    the bytearray will be having float,smallint,String with 8 bytes

    is there option to split based on the size...?

    There's a reason why these things are called "BLOBS". Splitting fixed length, fixed field blobs is nearly trivial if you know the "record layout" but when you add VARCHAR or any other variable length datatype to the mix, it isn't going to work unless there's an embedded delimiter in the data or something that identifies the start of each field for every row.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)