Msg 102, Level 15, State 1, Line 24

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Msg 102, Level 15, State 1, Line 24

Author

Topic

vimaldreams
Starting Member

17 Posts

Posted - 2010-10-27 : 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

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-27 : 07:37:18

Each BEGIN needs an END

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources