var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: View a JPG from SQL2000 image field
I would like to retrieve and view .jpg pictures that have been stored in a Data Type "image", Length "16", SQL2000 field.
Any ideas on "How to......."
Thanks alot and enjoy
Too bad they don't show you the pain of getting the data in and out in chunks...
I mean puuuuuleeze
If you can avoid storing images in your database, do so...store the filepath where they are located on the server....
create table #t (n ntext)
insert #t values('abc')
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(n)
WRITETEXT #t.n @ptrval 'def'
select * from #t
drop table #t
If you can't doog luck
OK now for a big
creating a relationship between a database and file system may lead to cumbursome maintenance and recovery procedures. you still have to have the same amount of disk space anyway.