August 12, 2004 at 8:55 am
Hi
when I run the following statement in the query analyser, I get an error :
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
here is the statement :
CREATE TABLE [dbo].[tblGroups] {
drgrpid int IDENTITY (1, 1)
PRIMARY KEY CLUSTERED ,
drgroup varchar (100) NOT NULL ,
drlongcode varchar (100) NOT NULL ,
drattr_1 varchar (50) NOT NULL ,
drattr_2 varchar (50) NOT NULL }
any ideas as to why this is happening ?
thanks
August 12, 2004 at 9:10 am
Replace the brackets with parenthesis
/hm
August 13, 2004 at 1:07 am
thanks !
August 13, 2004 at 4:27 am
or replace {} with ()
CREATE TABLE [dbo].[tblGroups] (
drgrpid int IDENTITY (1, 1)
PRIMARY KEY CLUSTERED ,
drgroup varchar (100) NOT NULL ,
drlongcode varchar (100) NOT NULL ,
drattr_1 varchar (50) NOT NULL ,
drattr_2 varchar (50) NOT NULL )
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy