Using this Stored Procedure method of testing is a way to determine whether your SP produces the expected output.
Add all the Parameters your SP needs, then run the script to return records for that Query.

This approach streamlines database interactions, ensures consistent query execution, and enables quick verification that the procedure returns the exact information the application needs.

[SQK Server - Stored Procedure Tester]

CFFCS | CarrzSynEdit: | SQL Script

EXEC dbo.sp_MyStoredProcedure @MyID = 10, @ColeName = 'MyName';