How do I identify a blank uniqueidentifier in SQL Server 2005?

sql-server sql-server-2005 uniqueidentifier uuid
codingguy3000 picture codingguy3000 · Dec 18, 2009 · Viewed 13.4k times · Source

I'm getting a uniqueidentifier into a Stored Procedure that looks like this

00000000-0000-0000-0000-000000000000.

This seems like a simple thing, but how can identify that this is a blank uniqueidentifier?

If I get a value like this DDB72E0C-FC43-4C34-A924-741445153021 I want to do X

If I get a value like this 00000000-0000-0000-0000-000000000000 I do Y

Is there a more elegant way then counting up the zeros?

Thanks in advance

Answer

davek picture davek · Dec 18, 2009

compare to 

cast(cast(0 as binary) as uniqueidentifier)

?

Related questions

Convert NULL to empty string - Conversion failed when converting from a character string to uniqueidentifier

Using SQL Server 2005 how do I get the below statement or rather the output as i want it to be. SELECT Id 'PatientId', ISNULL(ParentId,'') 'ParentId' FROM Patients ParenId is a uniqueidentifier that allows NULL, but seems that query …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More