copying image data between tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

copying image data between tables

Author

Topic

paulthomas
Starting Member

2 Posts

Posted - 2002-09-26 : 05:59:53

how can I copy an image data-type from one record in tableA to a record in TableB

trying something like ..

update TableB
set ImgDataB = (select ImgdataA from TableA where indexA = 13)
where indexB = 13

wont work because you store the image that comes back as a result of the subquery in a temp object.

Any suggestions please?

thanks

Paul

nr
SQLTeam MVY

12543 Posts

Posted - 2002-09-26 : 06:54:36

update TableB
set ImgDataB = TableA.ImgdataA
where TableB.indexB = 13
and TableA.indexA = 13

oops

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Edited by - nr on 09/26/2002 09:55:13

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-09-26 : 08:48:55

update TableB
set ImgDataB = TableA.ImgdataA
from TableA, TableB
where TableB.indexB = 13
and TableA.indexA = 13

paulthomas
Starting Member

2 Posts

Posted - 2002-09-26 : 09:36:53

Arnold, NR

thats great, thanks alot, its worked fine!

all the best

Paul

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources