Friday 5 April 2019

Save & Retrieve Hindi, Marthi Content in Sql Server database


declare @str nvarchar(100)=N'मै, तुम, हम, वे , इन्होने , अपने , पराये'

select (@str)
Insert into test(TextName) values (@str)
----------where N is the Nvarchar value >> N = NVARCHAR
----------and field datatype should be nvarchar(max)




         

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...