Somany friends asked me about
What is Database testing.
How we test that.
What is Data migration testing.
What we are trying to test in that.
Now iwill tell about
How to test stored procedure or stored procedure testing
Test coverage criterion: each and every stored procedure must be tested at least once
Individual procedure tests
Verify the following things and compare them with design specification
Whether a stored procedure is installed in a database
Stored procedure name
Parameter names, Parameter types and the number of parameters
When output is zero (zero row affected)
When some records are extracted
Output contains many records
What stored procedureis supposed to do
What a stored procedure not supposed to do
Write simple quaries to see if a stored procedure populates right data
Check parameters if they are required
Call stored procedures with valid data
Call procedures with boundary data
Make each parameter invalid a time and run a procedure
Whether a stored procedure returns values
When a failure occurs, nonzero must be returned
Make stored procedure fail and cause every error message to occur at least once
Find out any exception that doesnt have a predefined error message
Whether a stored procedure grants correct access privilege to a group/user
See if a stored procedure hits any trigger error ,index error and rule error
Look into a procedure code and make sure major branches are test covered
Integration tests of procedure:
Group related stored procedures together. Call them in particular order
If there are many sequences to call a group of procedures, Find out equivalent classes and run tests to cover every class
Make invalid calling sequence and run a group of stored procedures.
Design several test sequences in which end users are likely to do business and do stress tests.
Gee, my friends ask me about lots of things, but never about Stored Procedure Testing, not even once.
It's nice that you have chosen to bestow your great wisdom on us and also the readers of TeluguPeople.com, but, it is not really appropriate here. We tend to answer specific questions and not preach at the members nor post lengthy dissertations on theory, etc.
Thank you for the info.
Success is the ability to go from one failure to another with no loss of enthusiasm.
~ Winston Churchill ~