Binary Data Types : VARBINARY « Data Types « SQL Server / T-SQL Tutorial






6> CREATE TABLE MyTable (
7>      Id int,
8>      BinData varbinary(8000),
9>      Diagram varbinary(max))
10>
11> go
1>
2> Update MyTable
3>      Set BinData = 0x82A7210B
4>      where Id = 121131
5> GO

(0 rows affected)
1>
2>
3> drop table MyTable;
4> GO
1>








5.26.VARBINARY
5.26.1.Binary Data Types
5.26.2.VARBINARY(MAX)
5.26.3.VARBINARY type variable
5.26.4.CONVERT (varbinary(8), @today)