SRP0006.md

SQL Server Rule: SRP0006

Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Performance
Class	AvoidNotEqualToRule

Rule Information

Id	SRP0006
Friendly Name	Use of inequality
Category	Performance
Ignorable	true
Applicable Types	Procedure
	Scalar Function
	Table Valued Function
	View

Description

Try to avoid using not equal operator (<>,!=) in the WHERE clause if possible. (Sargable)

Summary

Avoid using not equal operator (<>,!=) in the WHERE clause. (Sargeable)