0
N is used to specify a unicode string.
In your example N prefix is not required because ASCII characters (with value less than 128) map directly to unicode.
However, if you wanted to insert a name that was not ASCII then the N prefix would be required.
Below
Select N'Wahi','Wahi'
0Awesome Comments!