Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use of N in commands
Message
 
À
09/03/2011 15:49:09
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01503083
Message ID:
01503089
Vues:
29
>>Is for Unicode support, http://support.microsoft.com/kb/239530
>
>Thus, in order to avoid unexpected situations, it is always recommanded to always put N in front a command line defined in a string, such as in my example. Is that correct?

Yes. There are a number of built-in stored procedures that require unicode strings (no particular reasoning behind it AFAIK).

The only downside is that your commands take more space internally - generally not an issue at all.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform