Code Analysis - semicolon statement terminators

dsbert

Is there any way to warn for missing semicolons on statements? In particular there are situations where missing semicolons can cause unpredictable behavior (THROW).

I understand the auto-formatter can add semicolons, but I'm more interested in a linting solution to warn for these issues.

Tom_C

Hi Dan,

At present the functionality you're after isn't possible, only the listed actions from the following articles;
https://documentation.red-gate.com/sp/sql-refactoring/sql-prompt-actions
https://documentation.red-gate.com/sp/sql-refactoring/sql-prompt-actions#SQLPromptActions-Insertsemicolons 

I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features!