Strictly speaking, a NEWID() would be converted to 2 BIGINTs, since a UNIQUEIDENTIFIER is 16 bytes, and a BIGINT is 8 bytes.

declare @test-2 table (nid uniqueidentifier not null primary key clustered )

insert into @test-2

select nid = newid() union all select nid = newid() union all select nid = newid() union all

select nid = newid() union all select nid = newid() union all select nid = newid()

order by 1

select

a.*,

l_bigint= convert(bigint,a.l_vbin),

r_bigint= convert(bigint,a.r_vbin)

from(

select

aa.*,

l_vbin= convert(binary(8),substring(aa.vbin,1,8)),

r_vbin= convert(binary(8),substring(aa.vbin,9,16))

from(

select

aaa.nid,

vbin = convert(binary(16),aaa.nid)

from

@test-2 aaa

) aa ) a

order by a.nid

Results:

nid vbin l_vbin r_vbin l_bigint r_bigint

------------------------------------ ---------------------------------- ------------------ ------------------ -------------------- --------------------

4133B328-4043-4A44-9213-07E12E739234 0x28B333414340444A921307E12E739234 0x28B333414340444A 0x921307E12E739234 2932744137742500938 -7920978655886208460

4CD74D85-6338-49E5-BA08-18022410F816 0x854DD74C3863E549BA0818022410F816 0x854DD74C3863E549 0xBA0818022410F816 -8841173771094858423 -5041753385367177194

29F137BE-F5AD-4082-8838-1A9C87C63F66 0xBE37F129ADF5824088381A9C87C63F66 0xBE37F129ADF58240 0x88381A9C87C63F66 -4740054921469656512 -8631119426260418714

BE73EB30-7189-4AD8-B905-1EF2B188E8AE 0x30EB73BE8971D84AB9051EF2B188E8AE 0x30EB73BE8971D84A 0xB9051EF2B188E8AE 3525038395534465098 -5114647774099871570

51CB86F6-D234-4E47-8417-D936D9E27F13 0xF686CB5134D2474E8417D936D9E27F13 0xF686CB5134D2474E 0x8417D936D9E27F13 -682634743861065906 -8928428906631758061

822AAE67-2F2E-4723-B267-DBBC75CDB54D 0x67AE2A822E2F2347B267DBBC75CDB54D 0x67AE2A822E2F2347 0xB267DBBC75CDB54D 7470955570463187783 -5591258809880431283