SQL Server Performance

What does the 'N' mean in 'SELECT = N'@test, @test1'?

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256, Dec 17, 2008.

  1. Trev256 New Member

    Does this mean collection?
  2. Adriaan New Member

    That doesn't look like the complete statement ...
    A leading N must be added before an opening quote when you are supplying a value for an NCHAR or NVARCHAR parameter, with a unicode character - for instance when calling sp_ExecuteSQL.
    EXEC sp_ExecuteSQL N'statement', N'parameter_list', N'value_list'

Share This Page