hi all, Why SQL adds "N" before a string value in query analyzer, i read something on UNICODE based characters! AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS
Yes it is for unicode http://www.aspfaq.com/show.asp?id=2522 ---------------------------------------- Cast your vote http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
It this compulsory, does it make a difference in the query execution time? AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS
if you are going to call sps with nvarcahr parameters then you have to use N ---------------------------------------- Cast your vote http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
I think better to use N to specify that they are NVarchars Madhivanan Failing to plan is Planning to fail
quote:Originally posted by Akthar It this compulsory, does it make a difference in the query execution time? AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS Since unicode data occupies twice the space nun-unicode data does it might very well make a difference. Use it only when you have to. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
