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.
| Author |
Topic |
|
ThillaiChidambaram
Starting Member
5 Posts |
 Posted - 2007-05-29 : 00:41:19
|
| The image is binary format in a table. I created one recordset from that table. Can i insert the image from the recordset to another table using insert into statement? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-29 : 00:54:33
|
| Yes you can. In .Net, you can use ByteArray object to store image data and use its HexString property in the INSERT statement. But this is not an ideal way and certainly not recommended for huge binary data.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
image insert from recordset