After a lot of time, I finally solved the problem of calling the stored procedure in the ASP without returning the result set.

It turns out that it is to be controlled using Set NoCount ON and SET NOCOUNT OFF. Use SET NOCOUNT OFF before you don't want to return the results, you want to return the result when you use Set NoCount Off.