What does 'N' means in this transact-SQL statement?

Hi,

I got these statements in an example of SELECT in MS SQL:

//----------
if exists (SELECT * from dbo.sysobjects WHERE id = object_id(N'dbo.employee') and OBJECTPROPERTY(id, N'IsUserTable')=1)
drop table dbo.employee
GO
//-----------

There exists an 'N' inside the above statement, I tried to figure out what it is, but I couldn't.

If you know, please help. Thanks

Rfr1tz



LVL 3
rfr1tzAsked:
Who is Participating?
 
Anthony PerkinsCommented:
It inidicates the character string is unicode (supports double byte character languages).
0
 
Anthony PerkinsCommented:
Take a look at the definition of OBJECT_ID:

<quote>
Returns the database object identification number.

Syntax
OBJECT_ID ( 'object' )

Arguments
'object'

Is the object to be used. object is either char or nchar. If object is char, it is implicitly converted to nchar.
</quote>

Notice how it supports the nchar data type.  nchar is a unicode datatype.
0
 
Anthony PerkinsCommented:
Also, as friendly reminder please maintain your many abandoned questions.  Here are listed all your open questions:

1 02/27/2005 250 Why Red Hat Linux Pro 9.0 no loner recog...  Open Linux Setup
2 03/18/2005 250 I want to download all the microsoft upd...  Open Windows 2000
3 03/22/2005 500 Lost in a maze of Cisco flexibility  Open Networking
4 04/04/2005 500 Approximate power budget for satellite c...  Open Networking
5 04/27/2005 125 Text marked with "Do not check spelling ...  Open Microsoft Word
6 04/30/2005 250 How to create a script to change content...  Open Microsoft SQL Server
7 05/01/2005 250 What does 'N' means in this transact-SQL...  Open Microsoft SQL Server
8 06/22/2004 250 How to define CONFIG_CRYPTO_HMAC inkerne...  Open Linux Setup
9 08/06/2004 250 How to make nslookup works without dns s...  Open Linux Setup

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.