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
7,148 total views, 3 views today