Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Sorting   (RSS)

How are GUIDs compared in SQL Server 2005?

In general, equality comparisons make a lot of sense with uniqueidentifier values. However, if you find yourself needing general ordering, then you might be looking at the wrong data type and should consider various integer types instead. If, after careful
Posted by mathh | 3 Comments

Sorting undefined characters in Unicode and/or Windows collation

When comparing two Unicode strings in non-binary collations, SQL Server uses a library that is essentially same as the Windows API CompareStringW. It defines a weight for each recognized character, and then use the weights to compare characters. However,
 
Page view tracker