system function syntax

#1

What does letter 'N' means in this syntax?

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[ImportFileData]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)

Thanks

#2

It's for Unicode data
See this article for further details
http://support.microsoft.com/kb/239530/EN-US/

Simon Worth

Lena wrote:

Quote:

What does letter 'N' means in this syntax?

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[ImportFileData]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

system function syntax

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

system function syntax - 03-22-2005 , 12:23 PM

Re: system function syntax - 03-22-2005 , 12:53 PM