Sergiy (4/8/2013)
quackhandle1975 (4/8/2013)
Odd reply, Sergiy. My comment was aimed at beginners and programmers who find themselves coding t-sql.I reread your comment 5 times more - it does not say anything about "beginners and programmers who find themselves coding t-sql".
Not a word. Not a hint.
Intead - you put the blame on triggers and called to avoid them.
Pretty stupid call.
Sorry.
I've seen .Net developers bringing dows 2 pretty powerful servers down by misusing remote calls in procedures.
And exausting server tresources by using front-end formatting in views.
What should we avoid here - remote calls, procedures, view?
Because we won't avoid stupidity and incompetence - it's ours everything!
Okay final comment on this matter. I hold my hand up and I should have mentioned that, where you can, try NOT to use CURSORS in TRIGGERS if you aren't aware of the consequences. I should have been clearer, I was not saying avoid triggers. That would be a daft call.
I'm big enough to handle criticism with grace and politeness, Sergiy I suggest you try the same. Thank you opc.three for the support.
Cheers
qh