31 lines (21 loc) · 686 Bytes

SQL Server Rule: SRD0036


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

Rule Information


Id	SRD0036
Friendly Name	Do not use SET ROWCOUNT
Category	Design
Ignorable	true
Applicable Types	Procedure
	Scalar Function
	Table Valued Function

Description

Do not use SET ROWCOUNT to restrict the number of rows.

Summary

Do not use SET ROWCOUNT to restrict the number of rows. Use the TOP clause instead.