binary(n)
for fixed-length binary data of length and
varbinary(max)
which is used to store large binary values (BLOBs)
binary(n)
variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes
varbinary(max)
variables store variable-length binary data of approximately n bytes. They may store a maximum of 2 gigabytes.
Reference Link ;-
Binary Data Types in SQL Server[
^]