SQL Server Hole #1
In my opinion SQL Server 2005 is full of holes, and my definition is functionality that is available doesn't span the whole gamete of the server. For example, aggregates don't work with GUIDs (call uniqueidentifiers in SQL). Here is non-working code that I would like to see work:
CREATE #Temp(Id uniqueidentifier, Name varchar(50))
SELECT MAX(Id)
FROM #Temp
DROP TABLE #Temp
Why doesn't this work? GUIDs are just 128-bit numbers, they are all unique and one comes before the other, there should be a MAX and MIN. This does work:
CREATE #Temp(Id uniqueidentifier, Name varchar(50))
SELECT MAX(CONVERT(varchar(41),Id))
FROM #Temp
DROP TABLE #Temp
However, I don't want the extra overhead of converting each GUID to a String.
Comments
Post a Comment