please solve my problem - 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)

please solve my problem

Author

Topic

rakesht23
Starting Member

1 Post

Posted - 2008-09-09 : 02:48:02

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoleMaster](
[RoleID] [int] NOT NULL,
[RoleName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ViewR] [tinyint] NULL,
[SaveR] [tinyint] NULL,
[PostR] [tinyint] NULL,
[ExcR] [tinyint] NULL,
CONSTRAINT [PK_RoleMaster] PRIMARY KEY CLUSTERED
(
[RoleID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

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

what is the error in

(
[RoleID] ASC

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-09-09 : 02:55:13

I don't get any error when executing your code.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-09 : 04:00:32

What is your compatibility level set to?

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources