<div>
create table test101 ( id int, name varchar(30), binarydata varbinary(200))<br />
<br />
insert into test101 values (1, 'Name', CAST(123445 AS VARBINARY))<br />
insert into test101 values (1, 'Name', CAST('ABCDE' AS VARBINARY))
</div>


create table test101 ( id int, name varchar(30), binarydata varbinary(200))

insert into test101 values (1, 'Name', CAST(123445 AS VARBINARY))
insert into test101 values (1, 'Name', CAST('ABCDE' AS VARBINARY))

<div>
Great! It worked. &nbsp;Can you please also tell me the correct syntax for converting the varbinary data into readable format (for instance, if I want to pass the data into a web browser via ASP).<br />
<br />
Thanks a bunch.
</div>


Great! It worked.  Can you please also tell me the correct syntax for converting the varbinary data into readable format (for instance, if I want to pass the data into a web browser via ASP).

Thanks a bunch.

<div>
Simply reverse it:<br />
<br />
SELECT ID, Name, CAST(binarydata as int) FROM Test101
</div>


Simply reverse it:

SELECT ID, Name, CAST(binarydata as int) FROM Test101

<div>
<div class="content wysiwyg-content">
I need a small SQL snippet which will allow me to insert values into fields set as varbinary. &nbsp;Can anyone help please?<br />
<br />
Thanks in advance,<br />
<br />
IPT
</div>
</div>


I need a small SQL snippet which will allow me to insert values into fields set as varbinary.  Can anyone help please?

Thanks in advance,

IPT

Insert into column with varbinary datatype

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.