• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

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



0
rfr1tz
Asked:
rfr1tz
  • 3
1 Solution
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now