Post reply

size of image fields?

  • March 13, 2006 at 2:10 am

    #112230

    Hi i have a image field which i insert images, i make it with sp_textcopy. First i upgrade field to '0x0' and later i do it the insert. But how could i know the size of the image stored in a image field ?

    Thanks

  • March 13, 2006 at 2:17 am

    #626170

    SELECT DATALENGTH(image_field) FROM tbl

    Returns the number of bytes that the field takes up. (replace image_field with the name of the field containing the image and tbl with the name of the table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 13, 2006 at 4:50 am

    #626179

    Many thanks

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

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