|
vimaldreams
Starting Member
17 Posts |
 Posted - 10/27/2010 : 07:34:09
|
When I Execute the following code it keep says the error ; Plz can anyone help me...its high priority
Msg 102, Level 15, State 1, Line 24
Incorrect syntax near ')'.
USE [CRM database];
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MK_DB]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[MK_DB](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Salutation] [nvarchar](50) NULL,
[First_name] [nvarchar](50) NULL,
[Last_name] [nvarchar](50) NULL,
[Address_line1] [nvarchar](50) NULL,
[Address_line2] [nvarchar](50) NULL,
[Town][nvarchar](50) NULL,
[Postcode][nvarchar](50) NULL,
[Telephone_no][nvarchar](50) NULL,
[Mobile_no][nvarchar](50) NULL,
[Email_address][nvarchar](50) NULL,
[Organisation][nvarchar](50) NULL,
[Org_type][nvarchar](50) NULL,
[Client_PartnerId][nchar](10) NULL,
[Work_type] [int] NULL,
[MK_Mailinglist][nvarchar](50) NULL
)
GO
|
|
Msg 102, Level 15, State 1, Line 24
