Which Error

Question

Which Error

Steve Jones - SSC Editor

SSC Guru

Points: 736078
More actions
July 15, 2022 at 12:00 am

#4060285

Comments posted to this topic are about the item Which Error

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

webrunner SSC-Dedicated Points: 31851 More actions · Answer 1

Thanks for this question, Steve. Especially because it explains another one of the generic errors that get returned from SQL Server, such as string or binary truncation etc.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 2

The correct answer should have been... find the person that wrote the trigger with an empty CATCH and have a nice pork chop dinner with them. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)