Nvarchar in Sql server

 Declare @val nvarchar(1000)

select @val = N'GFG में आपका स्वागत है'

select @val as HindiLanguage


Declare @val nvarchar(1000)

select @val = N'ಮಾಹಿತಿ'

select @val as kannadaLanguage

Comments

Post a Comment

Popular posts from this blog

Understanding Async and Await

Image
  To understand Async and Await, first we need to understand about 'Task'.  Task - This is used create thread but it will create thread from the thread pool and not from the computer operating system unlike normal Thread object in c# does. This is used to perform async operations 1. Task<TResult> - This return is used when the async method that returns a value. 2. Task - This return type is used when the async method does not return any value. 3. void - This return type is used for an event handler. We saw that concurrency refers to, in one way or another, doing several things at the same time. That concept of concurrency encompasses parallel programming and asynchronous programming. Parallel programming refers to the use of multiple threads simultaneously to solve a set of tasks. For this, we need processors with adequate abilities to perform several tasks at the same time. In general, we use parallel programming to gain speed. Asynchronous programming refers to the e...
Read more

Understanding Function Expression in Javascript - ES6

Image
  Functions - It can be written in three ways in JavaScript. we developers always think of writing it in old ways which is called as 'Function Declaration way' ex :      -It can be also written in variable assignment way. This is called 'Function expression'    ex:                                           The main difference between a function expression and a function declaration is the function name, which can be omitted in function expressions to create anonymous functions. Function expressions in JavaScript are not hoisted, unlike function declarations. You can't use function expressions before you create them: - Naming functions is useful if they need to reference themselves (e.g. for recursive calls). Indeed, if you are passing a literal function expression as an argument directly to another function, that function express...
Read more

Understanding ref and out + C#7.0 features

Image
ref and out - these are used in situations where some methods required to return multiple values from the method parameter list itself and not using 'return'  keyword, where method does not have 'return' keyword. Difference is -  1:ref variables must and should initialize or assigned the values before calling the method  2:out variables must be initialize or assigned the values inside the method. That is before leaving the method. In C#6.0, the out variables must and should be declared before calling the method. But in c#7.0,  the out variables can directly declared inside the method parameters c# 6.0 ------- int x , int y; obj.Math1(out x , out y); Here before using the variable it must be declared. c# 7.0 ------- obj.Math(out int x , out int y); Here we no need to declared it before using it in method parameters Tuple c# 6 ======= Tuple - these are used in situations where some methods required to return multiple values from the method, where method does have 'ret...
Read more