The following function returns the Guid.Empty (.Net constant) in MS SQL:
create function dbo.fn_empty_guid ()
returns uniqueidentifier
as
begin
declare
@result uniqueidentifier
set @result = cast(cast(0 as varbinary) as uniqueidentifier)
return @result
end
go
Usage:
select dbo.fn_empty_guid()
