It converts string to Unicode which corresponds to the data types nchar, nvarchar and ntext. Some system stored procedures require that string parameter be passed as Unicode.
>
>I quite often see the N character before string literals in SQL server ...
>
>
>@cursor_source = N'AnyOldString'
>
>
>What is the N for and what does it mean?
>
--sb--