Avira Antivirus Personal 8.2.0.337 more. You can insert into a varbinary(max) field using T-SQL within SQL Server Management Studio and in particular using the OPENROWSET commmand. For example: INSERT Production.ProductPhoto ( ThumbnailPhoto, ThumbnailPhotoFilePath, LargePhoto, LargePhotoFilePath ) SELECT ThumbnailPhoto.*, null, null, N'tricycle_pink.gif' FROM OPENROWSET (BULK 'c: images tricycle. Unc Charity Care Program. jpg', SINGLE_BLOB) ThumbnailPhoto Take a look at the following documentation for a good example/walkthrough Note that the file path in this case is relative to the targeted SQL server and not your client running this command.

How to simply insert or update to a BLOB column using data from file. DB2 Database Forums on Bytes. I am having trouble inserting in a BLOB field some. Insert string content into a blob in DB2. Browse other questions tagged sql db2 insert blob or ask.

The House On Sorority Row 1983 Rapidshare there. MSDN has an article which tries to explain how import works but it can get a bit confusing since it does 2 things together. So here's a simplified version and broken into 2 parts. Assume simple table: CREATE TABLE [Thumbnail]( [Id] [int] IDENTITY(1,1) NOT NULL, [Data] [varbinary](max) NULL CONSTRAINT [PK_Thumbnail] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) ON [PRIMARY] If you run (in SSMS): SELECT * FROM OPENROWSET (BULK 'C: Test TestPic1.jpg', SINGLE_BLOB) it will show that the result looks like a table with one column named BulkColumn. That's why you can use it in INSERT like: INSERT [Thumbnail] ( Data ) SELECT * FROM OPENROWSET (BULK 'C: Test TestPic1.jpg', SINGLE_BLOB) The rest is just fitting it into insert with more columns which your table may or may not have.