Sometimes we need to compare a value with an empty GUID in SQL Server, and used to do something like
myValue = '00000000-0000-0000-0000-000000000000'
But instead of this, we can also do
select cast(cast(0 as binary) as uniqueidentifier)
and compare with this.