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 |
|
waterduck
Aged Yak Warrior
982 Posts |
 Posted - 2009-09-17 : 21:56:56
|
[code]UPDATE TABLE SET column_varbinary = @column_varbinary = CAST('abc123' AS VARBINARY)[/code]how could i direct insert the varbinary data to it without converting?By using above statement, 'abc123' will be convert to varbinary again example 'def456'... i would like to insert 'abc123'
Hope can help...but advise to wait pros with confirmation... |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-09-18 : 11:59:44
|
| Why don't you want to use the CAST function?UPDATE TABLE SET column_varbinary = CAST('abc123' AS VARBINARY) =======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
|
|
|
update varbinary