Convert string to varbinary
hello,
how can convert text string varbinary?
thanks :)
the insert statement works pretty fine; see test script below. sure field in same order in select statement , that's varbinary field?
create table #test
(field1 int, field2 int, field3 varbinary(100))
go
insert into #test
select 1, 2, convert(varbinary, 'abcdefg')
go
drop table #test
olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de
SQL Server > Getting started with SQL Server
Comments
Post a Comment