asked on

Table variable and constraints

Running SQL server 2000 on Windows 2000 server

I have created a table variable. I cannot seem to assign a primary key.
I get the error:
Incorrect syntax near the keyword 'CONSTRAINT'.

See my code below:

What am I doing wrong?

DECLARE @tblAmibrokerRawTemp	table
    (Symbol		varchar(7)	NOT NULL	,
     EntryDate		smalldatetime	NOT NULL	
     	CONSTRAINT tblAmibrokerRawTemp_PK PRIMARY KEY(Symbol, EntryDate),
     Active		smallint	NOT NULL	DEFAULT 1)

Open in new window

Raja Jegan R

This should work:

DECLARE @tblAmibrokerRawTemp    table
    (Symbol             varchar(7)      NOT NULL        ,
     EntryDate          smalldatetime   NOT NULL        ,
     Active             smallint        NOT NULL        DEFAULT 1,
     CONSTRAINT tblAmibrokerRawTemp_PK PRIMARY KEY(Symbol, EntryDate)
)

Open in new window