How to write QA test Script

[suresh Gautam]

I have MS-SQL procedure for reporting purpose. It accepts various parameters and gives the table variable after applying the different logic.

Now, I need to write the test script to verify the procedure.

Can anybody advice me what would be the approach that I can follow here.

Note:
I am thinking to write the script that may gives the drilled down list of records, but doesn't seems effective, the queries being used in procedure would be repeated in the test script as well.

[r035198x]

I have MS-SQL procedure for reporting purpose. It accepts various parameters and gives the table variable after applying the different logic.

Now, I need to write the test script to verify the procedure.

Can anybody advice me what would be the approach that I can follow here.

Note:
I am thinking to write the script that may gives the drilled down list of records, but doesn't seems effective, the queries being used in procedure would be repeated in the test script as well.

I could be missing something here but I think this belongs in the MsSQL forum.

[Atli]

Hi, suresh Gautam, and welcome to TSDN!

I'm moving this thread to the SQL Server / MSSQL Forums, as this is not a MySQL related question and the experts over there are more likely to be able to give you answers on this topic.

Moderator

[Rao Singaraju]

Suresh
Obviously you have a query ready in your procedure.
As this is a query / procedure for query the data will not be modified. Hope you too agree.
The query is selecting certain data meeting some requirements, say employees from HR department, hired between March 07 and November 09, born between Sep 81 and Oct 84, with no bonus.
Having understood this query insert data qualifying this conditions and known employee id.
Then run the procedure with actual parameters. The report should bring all the data along with the data which you inserted.
This is one of the simplest method to run a test script for both TSQL or PL/SQL.
If you need to verify the table variable value, you need to use a DBMS_output.put line in case of pl/ sql and it’s equivalent in TSQL (any message function) as table table functions (global temporary tables in Oracle) cease to exist beyond the life of procedure(user session) which is creating it.
Hope this may give you some idea.
Thanks
Rao