sIMPLE qUESTION
-
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!
-
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
-
Thanks,
Erik...
Dam again!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply