Post reply

how to delete image column in sql server 2008

  • January 2, 2012 at 11:19 am

    #391232

    HI all,

    delete from photoTable where photo in (SELECT

    p.Photo

    FROM Master_table SOD

    INNER JOIN phototable P

    ON SOD.x = P.vex

    WHERE SOD.uploaddate between '2011-10-01 00:00:00.000' and '2011-10-01 00:00:00.000')

    i got this error

    The data types image and image are incompatible in the equal to operator

    kindly suggest what to do ..

  • January 2, 2012 at 11:54 am

    #1427482

    This may be what you are attempting to accomplish.

    delete from dbo.phototable

    from

    dbo.Master_table sod

    inner join dbo.phototable p

    on (sod.x = p.vex)

    where

    sod.uploaddate = '20111001';

    The error you are getting is because you can't compare images.

  • January 2, 2012 at 10:38 pm

    #1427550

    thnks i just want to know is image datatype can we used in any compare condition or not.

    so we can not have compare condition in image datatype column

  • January 2, 2012 at 11:48 pm

    #1427560

    Ivan Mohapatra (1/2/2012)

    thnks i just want to know is image datatype can we used in any compare condition or not.

    so we can not have compare condition in image datatype column

    I think I answered that in my original post as well.

  • January 2, 2012 at 11:59 pm

    #1427561

    yes u have .thks for ur suggestion.

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

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