Welcome to Julian Kuiters Sunday, May 27 2018 @ 01:32 PM AEST

Answer: How do you create a byte with the value of 00000001 in SQL Server?

  • Contributed by:
SQL Server 2005

My team mate Pi asked me today: how do you create a byte with the value 00000001 in SQL Server?

The answer is to create an integer representation of the byte's value, and cast it to binary.

SELECT CAST(CAST(1 AS TINYINT) AS BINARY(1))

The output in Management Studio is: 0x01 (Management Studio outputs binary fields in Hex format). Hex 0x01 = Bits 0000001.