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 |
|
AmitKumar123
Starting Member
1 Post |
 Posted - 2012-10-21 : 14:19:51
|
| hello, i have two tables. one is dbo.customer.Image and the other table is dbo.register.image.i have one table in customer database. and want to copy the binary data of images into the table of register database.i have same image data type column in both tables of different database.please tell me the easy and simple way.also tell me the fastest way so that i can copy the bulk amount of database for eg. in case of signature record of account holders in bank.Amit Saini |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-21 : 20:34:22
|
The most straightforward is:INSERT INTO dbo.register ([image])SELECT [image] FROM dbo.Customer; |
 |
|
|
|
|
|
Copying binary data of image source from one datab