What does N'??????' mean?

• Howard Perry

  Right there with Babe

  Points: 761

  More actions

  January 28, 2009 at 9:49 am

  #75401

  Example.

  IF EXISTS (SELECT name

  FROM sysobjects

  WHERE name = N'ReturnResponseByEventRS'

  AND type = 'P')

  DROP PROCEDURE ReturnResponseByEventRS

  Also I've seen it used in create database sql after keywords

  NAME= and FILENAME =.

  Thanks for enlightening me.

  Howard

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  January 28, 2009 at 9:57 am

  #933949

  N means 'National'

  It is used when you want to ensure that the value you are passing is a Unicode value

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  January 28, 2009 at 9:57 am

  #933950

  N' means Nchar or Nvarchar meaning it is Unicode text data.

  Kind regards,
  Gift Peddie