SSMS option for lower case GUIDs

Question

Visual Studio distinguishes between upper and lower case guids. By default, VS saves them in lower case. Because SQL prints them in upper case, frequently, it is too easy to have duplicate guids in Visual Studio coding because of case. For example:

CREATE @GUID UNIQUEIDENTIRY = '2B170864-94BC-4BA8-8F92-0006CE5D76D2'

CREATE @GUID UNIQUEIDENTIRY = '2b170864-94bc-4ba8-8f92-0006ce5d76d2'

Visual Studio sees these are different. The human eye can see they are the same other than by case. Also VS has the ability to tell them apart - it must be told to tell them apart. SQL Server is case insensitive and prints in upper case for GUIDs.

I'm asking for an OPTION to print them in lower case. Can MS add this task to the SQL Server Managment Studio options capability?

Answer 1

Hi @Longstreet, James [USA]

To convert text to lowercase, press CTRL+SHIFT+L, or click Make Lowercase on the Advanced submenu of the Edit menu.

See: To switch text to upper or lower case.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".