[dba-SQLServer] SQL syntax question

This syntax supports multi-byte encoding of the data, for such alphabets as
Cyrillic as well as Asian ideographic languages. It simply ensures that your
SQL will work with these languages as well as staid old English :)

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Pete
Phillipps
Sent: September 19, 2005 7:06 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] SQL syntax question

Hello Everyone,

	I am currently working on learning more about SQL Server 2000 and
was wondering what the reason for the N syntax in the first WHERE clause was
which was in the script SQL generated. Both statements seem to produce the
same results in Query Analyzer.

SELECT * FROM sysobjects WHERE  name = N'Players' AND type = 'U'

SELECT * FROM sysobjects WHERE  name = 'Players' AND type = 'U'

 	Thanks for any help.

Pete

"Many [wargame] battles have been fought and won by soldiers nourished on
beer" - Frederick the Great, 1777
Download VIEW FROM THE TRENCHES (Britain's Premier ASL Journal) free from
http://www.vftt.co.uk
Get the latest news about HEROES(ASL in Blackpool) at
http://www.vftt.co.uk/heroesdetails.htm
Get the latest news about INTENSIVE FIRE (Britain's biggest ASL tournament)
at http://www.vftt.co.uk/ifdetails.htm
Support the best at http://www.manutd.com/

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com