Home

Rule description

• Unused local variables should be removed

Non-compliant Code Example

CREATE TRIGGER [DATA].COUNTER_Update
ON [DATA].COUNTER
AFTER UPDATE 
AS

BEGIN
	DECLARE @n int  --Non complaint code (Unused local variable)
    PRINT ' Update the counter'
END