You can find this information about the N-prefix in the BOL:
Unicode string constants that appear in code executed on the server, such as in stored procedures and triggers, must be preceded by the capital letter N. This is true even if the column being referenced is already defined as Unicode. Without the N prefix, the string is converted to the default code page of the database. This may not recognize certain characters.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **