Post reply

Comparing varbinary(max) data type in SqlServer 2005

  • February 24, 2009 at 3:59 am

    #128544

    Hi All,

    Currently I'm facing an issue in my project.I have a table which stores the content of Documents(Word and Excel) as varbinary in Database.I need to compare the contents of the documents.Is there any option by which we can compare varbinary types or is there any other alternative for comparing the data.Please help.

    Thanks & Regards,

    Vibindas

  • February 24, 2009 at 4:47 am

    #949242

    vibin.das (2/24/2009)

    Hi All,

    Currently I'm facing an issue in my project.I have a table which stores the content of Documents(Word and Excel) as varbinary in Database.I need to compare the contents of the documents.Is there any option by which we can compare varbinary types or is there any other alternative for comparing the data.Please help.

    Thanks & Regards,

    Vibindas

    I would use a FULL JOIN with CHECKSUM in the WHERE clause.

    Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

  • February 24, 2009 at 4:57 am

    #949244

    Can you please provide a sample for using the checksum.

    Thanks & Regards,

    Vibindas

  • February 24, 2009 at 5:47 am

    #949260

    Use full text

    Full-Text Indexes can query binary formatted data (Excel data, Word

    documents, etc.)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply