How to get an empty GUID in SQL Server

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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nit_singh

Software Developer (Senior)
India

No Biography provided

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

A method of comparing with an empty GUID

SQLSQL-Server
SqlServer

		9,998,966 members (45,385 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using