Execute the following script in Query Editor to import and export a jpeg photo image:

use AdventureWorks

-- Create image warehouse

create table dbo.ImageWarehouse (

[ImageWarehouseID] int identity(1,1) primary key,

[ImageName] varchar(100),

Photo varbinary(max))

Go

-- Import image

Insert into dbo.ImageWarehouse

([ImageName]) values ('5THAVE.JPG')

update dbo.ImageWarehouse

set Photo =

(SELECT * FROM OPENROWSET(BULK 'e:\image\photo\5THAVE.JPG', SINGLE_BLOB)AS x )

WHERE [ImageName]='5THAVE.JPG'

go

-- Check population

select * from dbo.ImageWarehouse

go

-- Export image

declare @SQLcommand nvarchar(4000)

set @SQLcommand = 'bcp "SELECT Photo FROM AdventureWorks.dbo.ImageWarehouse" queryout "e:\image\photo\exp5THAVE.jpg" -T -n -SPROD\SQL2005'

exec xp_cmdshell @SQLcommand

go