August 23, 2006 at 11:35 pm
i would like to store a physical picture in a database, (not the location) how can i do this using t-sql?
August 28, 2006 at 8:00 am
This was removed by the editor as SPAM
August 28, 2006 at 10:23 am
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.
August 29, 2006 at 1:18 pm
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