|
Reporting errors in queries.
I have a stored proc with two merge statements. SQL Server was showing the "can't update the same row twice", but was reporting the error on the first line of the stored proc (which was not where the first merge statement started).
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
The 2016 version of Management studio is supposed to have fixed a lot of these error line number discrepancies.
|
|
|
|
|
That have to do more than fix the reported line number. If they know there's an error, they can be a lot more detailed about what's causing the problem. In this day and age, reporting a "syntax error near ')'" is bullsh|t of the highest order.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Amen brother, spun my wheels yesterday on a similar issue. We are using JDBC Batch Update functionality talking to SQL Server and the stack trace gave me "incorrect syntax near where". I had to go monkey down in the bowels of our code to get the SQL string to output so I could see this "where".
Cutting to the chase, the code sets a source SQL query then you tell it which columns from the source match which columns of the destination and in a little black box it creates Insert and Updates statements.
Unless right after you set the source SQL query to immediately do a get of the same string for debugging purposes because that somehow wipes out the column information even before you add it.
 But I removed my debugging line and everything is hunky dory now.
Same but different, thanks for letting me vent.
|
|
|
|
|
Charles Manson dead at 83 - ![Jig | [Dance]](https://www.codeproject.com/script/Forums/Images/jig.gif) - no roses for that one.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Well, two dead great SOBs in 4 days... I like this week!
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
|
Salvatore Riina[^]. He had so many people killed that Manson pales in comparison. And the power he had, and still has...
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Perhaps you ought to request an animated :tarantella: emoticon for such occasions?
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
I prefer the :quadriglia: 
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
And there was I think the Mob (with Trilby's & Tommy Guns) were a thing of the past & only today on film... They had moved to more white collar stuff (the dreaded Cybercriminal) but no...
|
|
|
|
|
In Italy not so much, and right now it is using the unregulated clandestine immigration as their violent arm (basically our mob makes arrangement to get immigrant countries criminals and mobsters in Italy, retaining part of the profit and overseeing their operations) so that traditional "mafia" is less named in the news.
Yet there still are obvious italian mob killings, one of the last I heard of right in my city - which is at the far North, nominally way outside traditional mafia turfs but actually not, as my family personally knew dozens of affiliates of various kinds - and it was the murder of a local politician. Mafia always worked underway with bribes and blackmails, only with the occasional beating or "disappearance", until Riina got to power and started what was all but formally a terror campaign.
Sadly, the mob is still there, still powerful as usual, and now nobody speaks of it since it is back to the usual, quiet, self. People disappear, legal and public documents disappear, witnesses keep suddenly forgetting about what they did see, judges keep mudding trials and so on so forth.
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
"CP" deathwatch?
For a moment I was thinking Charles Manson's a CP user.  oops!
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
Some of us are at least as nuts as Manson, but we torture and kill only software. In the worst possible ways.
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
den2k88 wrote: but we torture and kill only software. In the worst possible ways
Also we do, to the innocent-first-time-lounge-tech-question-poster. 
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
Yup!
|
|
|
|
|
And Generalissimo Francisco Franco?
|
|
|
|
|
This breaking news just in, Generalissimo Francisco Franco is still dead!
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
As is Hitler!
There... I did it. Someone had to. It was inevitable!
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
|
Vunic wrote: I got furious & shouted at my wife
Couch for you tonight! 
|
|
|
|
|
Marc Clifton wrote: Couch for you tonight!
Slightly bigger for shredding. But still looks like a plan
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
First, say thank you, and I'm sorry.
Then you can start planning your revenge.
|
|
|
|
|
You can pop round and shred ours if you like, we have two large bags of the stuff.
Its fun at first but our shredder only takes 4-5 A4 sheets at once, after a while it gets a bit of a chore.
|
|
|
|
|
KennethKennedy wrote: Its fun at first but our shredder only takes 4-5 A4 sheets at once
Works for any size [^]
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
. I miss those papers *dammit*!
