Stored Procedure Testing

 I am in a healthcare project, where majority of the business written in stored procedures. How can i test the stored procedures to check the data is flowing per business or not? Is it through any testing tool i should use to achieve this? If Yes, then please tell me the tools name. I need to test the data field by field. Please confirm.