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 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

C# 6.0 Features

Image
  string interpolation - It is mainly introduced to remove string. Format. It is a new way of concatenating strings, manipulating strings and formatting strings Null conditional operator - this is used to avoid nullreference exception like object reference not set to an instance of an object. When we use this operator : it returns null as a value and wont throw any exception. Auto-property Initializer - This is used to set the properties values when they are declared at their place itself. Before this, we should use class constructor to initialize the properties to their default values. Dictionary/Index initializers - Before c#6.0, if we create Dictionary object then if you want to add any items into it, then we need to use Add() method. Now in c#6.0, we can do it similar to collection or object initializer way. Expression-body-function : This is nothing but similar to writing normal  code inside methods only this here we dont use "RETURN" keyword to return anything. Here we ...
Read more