Whats wrong with this query? - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Whats wrong with this query?

Author

Topic

john.leung@citect.com
Starting Member

1 Post

Posted - 2007-06-08 : 00:29:40

trying to execute in SQL 2005 to create a table:

USE [Cost]
GO
/****** Object: Table [dbo].[CostTable] Script Date: 06/08/2007 12:05:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CostTable](
[ID] [int] IDENTITY(1,1) NOT NULL,
[AccountingMonth] [int] NOT NULL,
[ExpenseCategory] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[PrimaryCostArea] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[SecondaryCostArea] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Cost] [float] NULL,
CONSTRAINT [PK_CostTable] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

and I am getting:

Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.

But I can't see anything wrong with any missing parantheses...

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-08 : 00:44:06

Tried on my server, worked ok.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-08 : 00:47:52

John,

are you using 2000 or 2005 ? It is fine on my 2005 server and get the same error in 2000

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-08 : 06:08:13

This line cannot be created with code.
Don't know if it is a bug or not.

WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources