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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 insert binary data

Author  Topic 

adamsmithhrs
Starting Member

2 Posts

Posted - 2008-01-04 : 10:39:42
Hi my first post so be gentle :D

I have a table which has a column of type binary(200)

I want to put some test data into this table just using sql server managment studio express

how do i do this i keep getting message which says

"the changed value in this cell was not recognized as valid .NET framework data type: Byte[]"

Thanks,

Adam

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-01-04 : 11:59:17
declare @t table(col binary(200))

insert @t (col) values (0x0123456789)

select * from @t


elsasoft.org
Go to Top of Page
   

- Advertisement -