For educational purposes, I would genuinely appreciate it if one of the folks who take issue with the "most of the time" factor could illustrate a scenario in which that...

I'm completely confused by this explanation. Especially this part:

However, since the last insert in the second Transaction was invalid, no rows were inserted into table2. So B not C...

Exactly. I knew I was answering the question incorrectly -- it was the result I...

Excellent question. I came up with five or six possible reasons why the SP might not work, and ruled each of them out in turn. Of course I...

tommyh (11/16/2010)

---

Richard Warr (11/16/2010)

---

Please don't describe questions as "nonsense", people take taime to set them and always have good intentions when they do so. It doesn't help your case if...

I'll throw in my proper case function just for laughs...

ALTER FUNCTION [cf_ProperCase] (@String varchar(MAX))

RETURNS varchar(MAX)

AS BEGIN

DECLARE @ReturnString varchar(max),

...

I had to stare at it a long while, but I finally came up with the right answer without running any queries or researching... woo-hoo! :w00t: Nice question!

ron

I don't claim to be an expert on the subject, but when faced with a query like this:

SELECT field

FROM table

WHERE (field LIKE '%A%') OR (field LIKE '%B%')

I find I get...

Great question. I was torn between the correct answer and the single record returning 0... I don't mind having gotten it wrong. 😀

ron

Yep, I've been bitten by that one more than once. Until you learn that int/int "gotcha" it can be nearly impossible to troubleshoot a script that is experiencing it....

Good question. In retrospect it seems obvious, and I think that's why I didn't go with the obvious answer. Like others I researched the question as far as...

As I understand...

I saw the semicolon, said "well that looks wrong," and then proceeded to ignore it completely and got the answer wrong. Shows how smart I am.

I knew it had to be trailing spaces. It's always trailing spaces... 😉

This is a great question, and I'm proud that I managed to work out the correct answer once I realized the first statement was going to try and cast 'test'...