Post reply

images

  • August 23, 2006 at 11:35 pm

    #173912

    i would like to store a physical picture in a database, (not the location) how can i do this using t-sql?

    thanks

  • August 28, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 28, 2006 at 10:23 am

    #657141

    SQL Server has an IMAGE data type.  See "image data type" in BooksOnLine.  I recommend that you search for "image data type" on this site to get more opinions on the pros and cons of storing large binary data in SQL Server.

    Greg

    Greg

  • August 29, 2006 at 1:18 pm

    #657364

    I don't think BLOB(IMAGE/TEXT) can be insterted using normal instert statement. The way I have done in past is using VB. You have to use "GetChunk" and "AppendChunk" method.

    Hope this helps.

    Thanks

    Sreejith

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

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