Cast uniqueidentifier to binary

Question

Hi. how can i Cast uniqueidentifier to binary in Sql? Thanks.

Answer 1

SELECT CAST(YourColumn AS BINARY)

Answer 2

Basically you will need to use CAST in SQL server -

DECLARE @program_guid uniqueidentifier, @program_binary binary(16)
--
SELECT @program_guid = '327EBEA7-3D4E-473A-8D72-7CB68AB51F73'
SELECT @program_binary = CAST(@program_guid AS binary(16))