SRD0024.md

SQL Server Rule: SRD0024

Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Design
Class	AvoidExecuteRule

Rule Information

Id	SRD0024
Friendly Name	Avoid EXEC or EXECUTE
Category	Design
Ignorable	true
Applicable Types	Procedure

Description

Avoid EXEC and EXECUTE with string literals. Use parameterized sp_executesql instead.

Summary

Avoid EXEC and EXECUTE with string literals or VARCHAR variables. Use parameterized sp_executesql instead.