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


  • This was removed by the editor as SPAM

  • 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.



  • 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.



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

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