79733602

Date: 2025-08-12 19:40:32
Score: 1
Natty:
Report link

You could use ROWCOUNT instead of SELECT TOP (@var) ... as:

SET @var = ISNULL(@var, 0)
SET ROWCOUNT @var
SELECT * FROM ...
SET ROWCOUNT 0

set ROWCOUNT 0 means all rows.

Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Xabi