Answer:
There are two ways to test a stored procedure.
1)Black box testing: The Result Set should be checked if the
desired output is returned by SQL command.
2)Performance Testing: Stored Procedures are created to
avoid compiling it again and again. hence, testing should be
done to check if stored procedures are reducing CPU load and
network traffic.
1)Black box testing: The Result Set should be checked if the
desired output is returned by SQL command.
2)Performance Testing: Stored Procedures are created to
avoid compiling it again and again. hence, testing should be
done to check if stored procedures are reducing CPU load and
network traffic.