Hello all,

how can I extract image strored in DB in to file?

Will something like this work?

DECLARE @cmd VARCHAR(2048)

SET @cmd = 'bcp select history_image from recipient where recipient_id = 1
queryout c:\test\625954.jpg '

EXEC master..xp_cmdshell @cmd, NO_OUTPUT

You want to use TextCopy.

e.g.
--OJ: TEXTCOPY example
-- Loading txt files into db


--create tb to hold data
create table tmp(fname varchar(100),txt text default '')
go
declare @sql varchar(255),
@fname varchar(100),
@path varchar(50)


--specify desired folder
set @path='c:\test\'


set @sql='dir ' + @path + '*.txt /c /b'


--insert filenames into tb
insert tmp(fname)
exec master..xp_cmdshell @sql


--loop through and insert file contents into tb
declare cc cursor
for select fname from tmp


open cc
fetch next from cc into @fname


while @@fetch_status=0
begin
set @sql='textcopy  /s"dev" /d"tempdb" /t"tmp" /c"txt" /w"where
fname=''' + @fname + '''"'
set @sql=@sql + ' /f"' + @path + @fname + '" /i'
print @sql
exec master..xp_cmdshell @sql,no_output
fetch next from cc into @fname
end
close cc
deallocate cc
go
select * from tmp
go
drop table tmp
go




Show quoteHide quote

Simple query?
adding 140,000 records requires index rebuild. make sense?
Need advice with a query
Index Tuning Wizard
Update Trigger