help in storing binary to image data type

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

General SQL Server Forums

New to SQL Server Programming

help in storing binary to image data type

Author

Topic

sign_seventh
Yak Posting Veteran

66 Posts

Posted - 2007-08-23 : 04:22:48

Hi. how can i store binary data to another field with image data types.

here is my sample code

--note: [CUD_DOCUMENT] and [RES_DOCUMENT] are image data type

DECLARE @CUD_DOCUMENT binary

SELECT @CUD_DOCUMENT = CUD_DOCUMENT FROM CUD_CONTINUOUS_UPLOAD_DOCUMENTS

INSERT INTO [RES_RESUMES](
[RES_DOCUMENT] -- image data type
) VALUES (
@CUD_DOCUMENT)

thnx for the help.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-23 : 04:28:12

INSERT INTO [RES_RESUMES]([RES_DOCUMENT])
SELECT CUD_DOCUMENT FROM CUD_CONTINUOUS_UPLOAD_DOCUMENTS
WHERE ...

E 12°55'05.25"
N 56°04'39.16"

sign_seventh
Yak Posting Veteran

66 Posts

Posted - 2007-08-23 : 04:48:20

ok thnx for the help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources