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