what is the mean N' in the store procedure

enrique_aeo used Ask the Experts™
hi experts, what is the mean N' in the store procedure
EXECUTE HumanResources.uspGetEmployees N'Ackerman', N'Pilar';
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The following link would give a brief idea;



the tex say
You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server,

if not use, like I can run the sp. That mean exactly?
Top Expert 2006
More explanation can be found here http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.html

As the text says if you going to deal with non English chars Unicode helps

Depends on your text now I guess.
Top Expert 2006

sorry, forgot to mention the line

Unicode is typically used in database applications which are designed to facilitate code pages which extend beyond the English and Western Europe code pages

code page refers to character encoding.

with reference to your question...Yes ...you can run the stored procedure without prefixing the N character.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial