I answer every email I receive in six hours and that is why sometimes I end up working over 18 hours in a day. However, sometimes I receive emails such that makes me wonder, how come I do not know some very simple stuff. Here is for example – today I received email where user asked how to INSERT or SELECT Copyright Special Characters in SQL Server. Trust me, in my early career, I used to know the answer to this, but I was not able to answer the user immediately. After quick googling, I was able to find out the appropriate character string.
Here is the character set which is appropriate to generate special character.
To generate © type ALT + 0169
To generate ® type ALT + 0174
To generate ™ type ALT + 0153
Well, that is it, you use above characters in your html or SQL Editor in SQL Server Management Studio and you would be able to generate those special characters.
Here is the link to all the special characters which can be generated with ALT Keyboard Sequences.
NOTE: I received a follow up question by a user who was not able to go find an ALT key on the keyboard. Here is a hint, the two keys which are besides your longest key (space-bar) with ALT mentioned on it, is the ALT key. Apple keyboards use the option key in place of the ALT key.
Reference: Pinal Dave (https://blog.sqlauthority.com)