How can i insert a SQL Server image datatype? 1

jollyplay · Feb 4, 2006

Hi,
I need to insert a image datatype data from one table to another table in the SQL Server.
Please provide me a suggestion.

Thanks in advance.

stefanwagner · Feb 4, 2006

Just a guess:
INSERT INTO t1 (image) SELECT image FROM t2 WHERE id=5432;

seeking a job as java-programmer in Berlin:

jollyplay · Feb 5, 2006

Thanks stefan. Its working.

Diancecht · Feb 8, 2006

Wow, stefan, your Java knowledge always impresses me.

Cheers,
Dian

stefanwagner · Feb 8, 2006

@dian: Of course you're free to get a blob from the db, keep it in an byte array, and send it to the other table.

Code:

statement.executeQuery ("INSERT INTO t1 (image) SELECT image FROM t2 WHERE id=5432");

better?

seeking a job as java-programmer in Berlin: