SEM006 : Count of SQL modules

Introduction

Description

Metrics rule - counts CREATE statements of stored procedure, trigger, function and views.

How to fix

The rule is only informational.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix

Not configured.

Additional Information

There is no additional info for this rule.

Example Test SQL

CREATE PROCEDURE testsp_CyclomaticComplexityTest
AS
BEGIN TRY

    IF (12 <1 )
        SELECT 1
    ELSE
        SELECT 2

END TRY
BEGIN CATCH

    IF (12 <1 )
        SELECT 1
    ELSE
        SELECT 2

END CATCH

IF (12 <1 )
    SELECT 1
ELSE
    IF (12 <1 )
        SELECT 1
    ELSE
        SELECT 2

RETURN;

IF (12>1)
    SELECT 4
ELSE
    SELECT 5

Analysis Results

	Message	Line	Column
1	SEM006 : SqlModulesCount=1	1	0

Analysis Rules