Click or drag to resize

SA0189 : Store procedure executed without getting a result

The topic describes the SA0189 analysis rule.

Message

Store procedure executed without getting a result

Description

The rule checks EXECUTE statements for stored procedure not being called and returned value assigned to a variable.

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.

Categories

Design Rules, New Rules

Additional Information

There is no additional info for this rule.

Example Test Script
1USE AdventureWorks2012;
2
3DECLARE  @result INT
4EXEC @result = dbo.uspGetWhereUsedProductID  819, '20050225';
5
6EXECUTE  dbo.uspGetWhereUsedProductID  819, '20050225';

Analysis Results

 MessageLineColumn
1SA0189 : Store procedure executed without getting a result.60
See Also

Other Resources