Home ยป Displaying Emoji in SQL Server

Displaying Emoji in SQL Server

In SQL Server we can create a database, table and write T-SQL query using emoji.




Lets create a table and then insert few records into table.

 Create table [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž] (EmojiId INT, EmojiName Varchar(20), Emoji NVarchar(MAX))

 

You can check whether a table is created or not by using object explorer.

As you can see table is created which have emojies as table name.

Lets insert some records into table.

Insert into [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž] values (1 , 'face with big eyes',N'๐Ÿ˜ƒ') 
Insert into [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž] values (2 , 'winking face',N'๐Ÿ˜‰')
Insert into [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž] values (3 , 'face with tongue',N'๐Ÿ˜›')
Insert into [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž] values (4 , 'face with tongue',N'๐Ÿ˜›')
Insert into [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž] values (5 , 'clown face',N'๐Ÿคก')

No we select records from table.

 select * from [๐Ÿ˜›๐Ÿ˜ˆ๐Ÿคช๐Ÿ˜Ž]

You can get more emojis from this website- Emojis




 1,517 total views,  1 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.