Showing posts with label Import. Show all posts
Showing posts with label Import. Show all posts

Tuesday, May 6, 2008

Importing an image into an image column using SQL 2005

Hi

Ever had to import an image into a column ? Here is a simple Insert statement...

Insert MyLogoTable (Logo)
Select BulkColumn
from Openrowset( Bulk 'c:\SomeJPEGFile.jpg', Single_Blob) as Logo


Cheers