Stored Procedure Database Testing SQL Server [closed]

What is the Best way to test Stored Procedure in SQL Server ?