Results 1 to 6 of 6
  1. #1

    Stored procedures and testing.

    What useful information can you get out of stored procs in database?. What kind of validation and testing hints can you get out of them?.

  2. #2

    Re: Stored procedures and testing.

    What are you trying to get from them?

    Usually I might look at them to see what they do, and run them independently to see that they do what they say.

    What about you?
    - M

    Nothing learns better than experience.

    "So as I struggle with this issue I am confronted with the reality that noting is perfect."
    - Unknown

    Now wasting blog space at QAForums Blogs - The Lookout

  3. #3

    Re: Stored procedures and testing.

    Are you doing white box testing or black box?


    a grey box? (looking internal and external both)

    Have you developed the stored procedure(seems not)


    Working as independent tester to do unit testing a.k.a. white box.
    Kind regards,
    Anand Tambey

    RSS Feed : Break To Make it Better
    A Lazy person could be the best automation professional, if he is not lazy in implementing his ideas to reduce his work. ~Anand Tambey

  4. #4

    Re: Stored procedures and testing.

    As the stored procedures implement some level of business logic of your application you may definitely use them to separate your testing depth. To levelize your testing approach.

  5. #5

    Re: Stored procedures and testing.

    If it white box, just make set of input data and then compare it with expecting result (master results).

    But, describe the problem more clear to let us give you better answer...

  6. #6

    Re: Stored procedures and testing.

    My advice is to run a Trace if Microsoft SQL or use logging if MySQL and then use your application.

    Now look at your trace/logs to see what stored procs were called.

    doing this you can match stored procs and their output to what the user sees on screen.

    This may then help or match to any test cases you have.
    select * from thetestmanager
    where content = 'Good'
    The Test Manager's Site



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 05:35 PM.

Copyright BetaSoft Inc.