Monday, March 19, 2012

dumb question, but I need help

Help people,

I am trying to figure out the syntax to declare a @.table varible with a primary key clusterd

Hence,

declare @.RANK_FIGROSS_TEST table
{
RANK int NOT NULL IDENTITY (1, 1)|PRIMARY KEY CLUSTERED,
FINAME nvarchar(255) NULL,
FIGROSS decimal (10,2)
}

But I am not having any luck, anyone know what I am missing ??should be ( and not { and no | for the primary key declaration

here is the code modified:

declare @.RANK_FIGROSS_TEST table
(
RANK int NOT NULL IDENTITY (1, 1) PRIMARY KEY CLUSTERED,
FINAME nvarchar(255) NULL,
FIGROSS decimal (10,2))|||that worked, told you it was a stupid question, just couldn't see it.

Thanks|||no such thing as a stupid question :-) we all have to learn somehow|||hmm.... I did even more stupid "ER" things than u ever imagined!!!
:)

No comments:

Post a Comment