Hi
The parameter is a National Character (Unicode) data type. From Books
Online: "The string must be either a Unicode constant or a variable that can
be implicitly converted to ntext. "
Unicode constants are specified with a leading N: N'A Unicode string'.
John
"DBA" <ka******@yahoo.com> wrote in message
news:ff*************************@posting.google.co m...
Does anyone know the technical reason for why sp_executesql uses the N
prefix before the string that is passed?
For example:
sp_executesql N'USE Northwind'
Thanks!