Syntax meaning

• sofiane-127187

  Valued Member

  Points: 59

  More actions

  March 9, 2005 at 9:03 am

  #86999

  Let's look at this statment :

  SELECT name

  FROM sysobjects

  WHERE name = N'<table_name, sysname, test_table>'

  AND type = 'U'

   

  I would like to know the meaning of :

  - N' (name=N'...)

  - the syntaxe : N'<table_name, sysname, test_table'> , why/when this form is used.

  Why not simply : name='test_table'

   

  Thanks a lot in advance

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 9, 2005 at 9:54 am

  #546179

  sofiane,

  N'  means you are going to use a unicode version of the string. Is usually required by nchar,nvarchar and ntext types. (btw sysname = nvarchar(128) )

  the systax means: <semantical meaning, type, example> with

  your 'name = test_table' you won't be able to know the TYPE or The  object meaning of "name" you are just using the example part.

  HTH

   

   

  
  * Noel