Home

Description

The SQL Server Code Rule "Syntax Errors" checks for syntax errors in Transact-SQL code. It ensures that the code is syntactically correct and that it can be parsed and compiled without any errors. This rule helps identify any syntax errors that may exist in the code and provides suggestions on how to fix them. It also flags any code that may be syntactically correct but may not produce the expected results. This rule is useful for ensuring that the code runs as expected and does not cause any unexpected errors.

Key Benefits

• Error identification: Syntax Errors help to identify errors in code quickly and accurately.
• Improved accuracy: Syntax Errors help to ensure that code is written accurately and without mistakes.
• Efficient debugging: Syntax Errors allow for efficient debugging of code, saving time and resources.
• Reduced complexity: Syntax Errors help to reduce the complexity of code, making it easier to read and understand.

Non-compliant Code Example

CREATE TABLE [DATA].[EMPLOYEE](
	[EMP_ID] [int] IDENTITY(1,1),
	[SALARY] [float] NULL --Non compliant code (Missing COMMA)
	[dept_id] [int] NULL,
	[manager_id] [int] NULL);