sIMPLE qUESTION

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  August 15, 2005 at 9:37 pm

  #89503

  What does the N' Stand for??

  Like in the example below??.....

   

  ALTER TABLE [dbo].[AttributeExtendedValues] DROP CONSTRAINT FK_AttributeExtendedValues_Attribute

  GO

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

  ALTER TABLE [dbo].[ProductAttribute] DROP CONSTRAINT FK_ProductAttribute_Attribute

  GO

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

  drop table [dbo].[Attribute]

  GO

   

  Thanks,

   

  Erik...

  Dam again!

• philcart

  SSC-Forever

  Points: 47797

  More actions

  August 15, 2005 at 9:53 pm

  #582329

  The uppercase N at the start of a string signifies that the string is in unicode format.

  Most of the SQL Server object names, functions and stored procedures use unicode string to support multiple languages.

   

  --------------------
  Colt 45 - the original point and click interface

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  August 15, 2005 at 9:58 pm

  #582330

  Thanks,

   

  Erik...

  Dam again!