The purpose of N in sql server

is to denote that the literal is unicode
some stored procedures only take nvarchar so then the N would be necessary
Here and here.