I have a table with a varbinary data column, I want to copy the data to another table but when I try I get errors even though I have set the receiving column to varbinary.
I am obviously missing something here, can anyone help?
regards
Asked
Active
Viewed 99 times
0
-
Yes, you are obviously missing something, at least the error message given sql server, and query on which it gives you. – Hamlet Hakobyan Feb 01 '14 at 19:52
-
ah ha, good point Hamlet – Davea Feb 01 '14 at 19:54
-
Just doing a straight copy and paste from one field to another give error The changed value in this cell was not recognised as valid .NET Framework Data Type:Byte [] – Davea Feb 01 '14 at 19:55
-
Are you using some edit top n rows grid to copy data between tables? Hint: SQL Server is not a spreadsheet. Why don't you try writing an INSERT or UPDATE statement? – Aaron Bertrand Feb 01 '14 at 20:11
-
Hi aaron I was using edit, stupidly haven't tried insert or update – Davea Feb 01 '14 at 20:14
-
I think the issue I have is that I cant see the data as its displayed as
– Davea Feb 01 '14 at 20:20 -
Ok have changed my method and am now using an update statement. I know get the error The multi-part identifier "rfidsink.dbo.TagEvents.TagId" could not be bound. UPDATE [rfidsink].[dbo].[AssetMaster] SET [RFIDcode] = [rfidsink].[dbo].[Tagevents].[TagId] WHERE [rfidsink].[dbo].[AssetMaster].[AssetCode]='Defibulator'; GO – Davea Feb 02 '14 at 09:35