SQL Server Performance

what this N stand for in SQL Server.

Discussion in 'General Developer Questions' started by raj_id, Mar 29, 2004.

  1. raj_id New Member

    [?]what this N stand for in SQL Server and Why we need that.

    DECLARE @query NVARCHAR(100)
    SET @query = N'SELECT * FROM '+ 'Shippers'

    plz email me at:krajeevs@yahoo.com
  2. satya Moderator

    When dealing with Unicode string constants in SQL Server you must precede all Unicode strings with a capital letter N, as documented in the SQL Server Books Online topic "Using Unicode Data". The "N" prefix stands for National Language in the SQL-92 standard, and must be uppercase. If you do not prefix a Unicode string constant with N, SQL Server will convert it to the non-Unicode code page of the current database before it uses the string.

    (in future kindly post your question in appropriate forum)

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page