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 |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2010-06-17 : 08:13:17
|
Hi, I have a table called tblUser with field called Signature as image datatype. I have another table called tbltest with field called Signature as image dadatype. I popualted tbltest with the following; Insert into dbo.Tbltest(Signature)Select * from OPENROWSET(BULK N'C:\Signatures\Gerry.JPG', SINGLE_BLOB) as signature Now, am trying to copy the image from tbltest to tbluser. Note, when the image was saved it was set as <binary data>.I receive the Error; The Changed value in this cell was not recognised as valid. .Ner Framweork data type: Bytes[] Error Message: You cannot use the Result pane to set this field data to values other than NULL. Type a value appropriate to the data type or press Esc to Cancel..Any help please |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-17 : 09:02:26
|
You cannot use the Result pane to set this field data to values other than NULL.Isn't that information enough?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Copy image data type from one table to another