Bug With Fillfactor

torsten.strausstorsten.strauss Posts: 271 Silver 3
in SQL Prompt
Hi !

The following syntax will successfully parsed but SQLPrompt will raise an error.

ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)
WITH FILLFACTOR = 100;
GO

The official syntax includes FillFactor in square brackets, but SQLPrompt suggests FillFactor without these brackets.

ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)
WITH (FILLFACTOR = 100);
GO

Therefore, either remove "FillFactor without brackets" from the proposal, or make sure SQLPrompt does not throw an error if brackets are not used.

Thanks!

Torsten
MVP
Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.