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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!