Parameterize the T-SQL TOP clause

parameterized_top.sql

CREATE PROCEDURE dbo.sp_TestGetAll    
    @LIMIT INT
AS
    SELECT TOP (@LIMIT) id, col1, col2, col3 FROM TestTable