Monday, 18 June 2012

Unicode in SQL SERVER

    What is Unicode character string :   

       In sql server , unicode character string starts with "N"  i.e nvarchar,nchar etc

       Main purpose to use it... it acceptss universal character string and "N" stands for NATIONAL   LANGUAGE.

        When we are executing query in sql sevrer with parameters , sql server displays list of values preceded with N 'Hello'  etc      

        @p_id = 6,
        @p_desc = N'sas',
        @p_msg = @p_msg OUTPUT


          More details

No comments:

Post a Comment