Question: EXEC spBalanceRange @BalanceMin = 200, @BalanceMax = 100 What does the exec above produce in terms of results. If the maximum was coded to be
EXEC spBalanceRange @BalanceMin = 200, @BalanceMax = 100
What does the exec above produce in terms of results.
| If the maximum was coded to be $100, then nothing would be returned because there is no error-checking in the stored procedure, and you can't have a minimum of 200 and maximum of 100, thus no companies would fill that criteria | ||
| If I were to recode this statement with a @BalanceMax of 100, I would get an error because it is not possible to have a value between a min of 200 and max of 100. | ||
| It would return nothing, because the minimum and maximum amounts do produce a valid cross-section to return matching data. | ||
| In terms of results, this Exec returns Vendors with a balance between 200 and 100 dollars. | ||
| There are no Vendors with a 'Balance' between 100 and 200 dollars. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
