Generating Guid.Empty in SQL Server

EmptyGuid.sql

--
-- 2021-11-24: suggestion from comments:
--
DECLARE @EmptyEmpty UNIQUEIDENTIFIER = CAST(0x0 AS UNIQUEIDENTIFIER)
SELECT @EmptyEmpty


--
-- Original
--
DECLARE @EmptyGuid UNIQUEIDENTIFIER
SET @EmptyGuid = (SELECT CAST(CAST(0 AS BINARY) AS UNIQUEIDENTIFIER))

-- Single result is 00000000-0000-0000-0000-000000000000
SELECT @EmptyGuid

Nice!!!

Even simpler

DECLARE @EmptyGuid UNIQUEIDENTIFIER = 0x0
SELECT @EmptyGuid

Or

SELECT * FROM Table WHERE GuidColumn = 0x0

2 cents:

select cast(0x0 as uniqueidentifier)