Emojis Using Supplementary Characters or Surrogate Pairs

SELECT '0xD83D and 0x' + CONVERT(VARCHAR(10), [Code], 2) AS [Surrogate Pairs], [Name],
    NCHAR(0xD83D) + NCHAR([Code]) AS [Emoji]
FROM (VALUES (0xDE00, 'Grinning Face'), (0xDE01, 'Beaming Face With Smiling Eyes'),
            (0xDE02, 'Face With Tears of Joy'), (0xDE03, 'Grinning Face with Big Eyes'),
            (0xDE04, 'Grinning Face With Smiling Eyes'), (0xDE05, 'Grinning Face With Sweat'),
            (0xDE06, 'Grinning Squinting Face'), (0xDE07, 'Smiling Face With Halo'),
            (0xDE08, 'Smiling Face With Horns'), (0xDE09, 'Winking Face'),
            (0xDE0A, 'Smiling Face With Smiling Eyes'), (0xDE0B, 'Face Savoring Food'),
            (0xDE0C, 'Relieved Face'), (0xDE0D, 'Smiling Face With Heart-Eyes'),
            (0xDE0E, 'Smiling Face With Sunglasses'), (0xDE0F, 'Smirking Face'),
            (0xDE10, 'Neutral Face'), (0xDE11, 'Expressionless Face'))
AS Emojis ( [Code], [Name] );

Surrogate Pairs	Name	Emoji
0xD83D and 0xDE00	Grinning Face	😀
0xD83D and 0xDE01	Beaming Face With Smiling Eyes	😁
0xD83D and 0xDE02	Face With Tears of Joy	😂
0xD83D and 0xDE03	Grinning Face with Big Eyes	😃
0xD83D and 0xDE04	Grinning Face With Smiling Eyes	😄
0xD83D and 0xDE05	Grinning Face With Sweat	😅
0xD83D and 0xDE06	Grinning Squinting Face	😆
0xD83D and 0xDE07	Smiling Face With Halo	😇
0xD83D and 0xDE08	Smiling Face With Horns	😈
0xD83D and 0xDE09	Winking Face	😉
0xD83D and 0xDE0A	Smiling Face With Smiling Eyes	😊
0xD83D and 0xDE0B	Face Savoring Food	😋
0xD83D and 0xDE0C	Relieved Face	😌
0xD83D and 0xDE0D	Smiling Face With Heart-Eyes	😍
0xD83D and 0xDE0E	Smiling Face With Sunglasses	😎
0xD83D and 0xDE0F	Smirking Face	😏
0xD83D and 0xDE10	Neutral Face	😐
0xD83D and 0xDE11	Expressionless Face	😑