Bug With Fillfactor
torsten.strauss
Posts: 266 Silver 3
in SQL Prompt
Hi !
The following syntax will successfully parsed but SQLPrompt will raise an error.
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.
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
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:
Answers
I see this occurring as well and I have reported it to the team as SP-7766. I will update you when I have further information from the team!
Kind regards,
Alex
Have you visited our Help Center?
This issue should now be fixed in the latest version. Please update and let me know if you still experience any issues!
Kind regards,
Alex
Have you visited our Help Center?