Skip to content

SRD0024.md

Latest commit

 

History

History
29 lines (19 loc) · 679 Bytes

SRD0024.md

File metadata and controls

29 lines (19 loc) · 679 Bytes

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.