Search results for query: *

Is there a way to immediately stop execution of a stored procedure that has an output parameter anytime certain criteria is met? My situation is this (cheap SP skeleton) : if errorcheck begin set @outputString = 'error' --if I hit this error, I don't need to execute anymore of the SP end...

Hello gurus, I have a question regarding a situation. I have a query that was originally build dynamically using ASP. The ORDER BY clause can 4 different "values", based on a value in an ASP variable. Here is my question. What is the best way of going about putting these different scenarios...

I have a question for the masses. I won't be able to respond until tomorrow, so that will be why you don't see a response. I'm pretty sure using the LIKE clause and LEFT statement on chars and varchars are not sargeable. If one of them is, please tell me (I know LIKE isn't). What would be...

Is there a way to use the FillRectangles method on an array of rectangles and be able to specify a different color for each rectangle if I choose? Or do I have to draw each rectangle separate and fill them that way??? [monkey][snake] <.

What does the following evaluate to and which path does it take?? SELECT CASE 2 WHEN '2' THEN CASE 3 WHEN 2 THEN 5 ELSE CASE 9 WHEN 5 THEN 3 ELSE 0 END END ELSE CASE 0 WHEN 2 THEN 5 ELSE 0 END END [monkey][snake] <.