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