As we learned for the import the images into the database from folder in the last post. One more thing is also interesting to learn here as how can we extract images from database.
SP_CONFIGURE 'Ole Automation Procedures',1 GO RECONFIGURE GO SELECT * FROM [IMAGEINSERT] GO DECLARE @Image VARBINARY(MAX) SELECT @Image = (SELECT [Image] FROM [IMAGEINSERT] ) DECLARE @ObjectImage INT EXEC sp_OACreate 'ADODB.Stream', @ObjectImage OUTPUT EXEC sp_OASetProperty @ObjectImage, 'Type', 1 EXEC sp_OAMethod @ObjectImage, 'Open' EXEC sp_OAMethod @ObjectImage, 'Write', NULL, @Image EXEC sp_OAMethod @ObjectImage, 'SaveToFile', NULL, 'D:\image\ImageExport.jpg', 2 EXEC sp_OAMethod @ObjectImage, 'Close' EXEC sp_OADestroy @ObjectImage
Comments
Post a Comment