Hi

I need to make test plans for some sql select queries, what conditions
or things I should test?
I was thinking of testing where clause for data types etc?

any help is greatly appreciated

thanks

First, you need to have clear criteria that defines success/failure.

If you are testing application embedded queries, then you need to test for
any and all possible input values and datatypes as well as JOIN conditions
and all WHERE criteria.

If you are testing stored procedures, then you need to test JOIN conditions
and WHERE criteria, conversions to input parameters, and any conditions that
activate 'switching code', i.e., IF | ELSE | WHILE.


Show quoteHide quote

column dataType
Joining 2 select statement with like fields
Views and CTEs performance problem
Adding a space in a field
Applying a function to a subquery