November 12, 2019 at 12:00 am
Comments posted to this topic are about the item Computed Column Indexes
November 12, 2019 at 1:32 pm
Steve, thanks for the question. As is, you get a syntax error because of the schema in the Create Index statement. If you remove the schema,then it works fine.
As is:
CREATE INDEX dbo.Activities_PRodOneCountThreshold
ON dbo.Activities (ProdOneCount)
WHERE CallCount > 50;
GO
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '.'.
Completion time: 2019-11-12T08:29:28.6131625-05:00
Corrected:
CREATE INDEX Activities_PRodOneCountThreshold
ON dbo.Activities (ProdOneCount)
WHERE CallCount > 50;
GO
Commands completed successfully.
Completion time: 2019-11-12T08:31:08.5595316-05:00
November 13, 2019 at 10:36 am
nice question, thanks Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
November 13, 2019 at 2:59 pm
Thanks, fixed that. That's what I get for trying to edit the code after it's pasted in. Trying to set better examples with schema qualification and was just racing through each object.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply