Natural recursion of SQL Server Stored Procedures

Several times, when I write or modify a stored procedure, for the convenience of the graph, write the statement to execute the stored procedure at the end, such

Alter procedure prd_getdata @ top Int = 10; asselect * from [DBO]. Table1 order by id desc; endexec [DBO]. prd_getdata

You should have selected the last row with the mouse and specified it for execution. However, at the moment, the system trembled and pressed it to run without being selected. Many results were returned. At last, the system warned too many layers and the SQL statement exited automatically.

The reason is that the system

Exec [DBO]. prd_getdata

This statement is also used as a statement of the stored procedure itself to form recursion, so there is an infinite loop.

Stored Procedure

Tune up one hundred and eighty turtles