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
Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)