|
Trying to learn something.
Step one - search BOL
Step two - try code from BOL
Step three - IntelliSence lets me know bad column names, put in the correct column names for table
Step four - run code
Works!
Step five - annotate code by putting in comments at the end of the lines and rerun
(This should work as it drops the trigger then recreates it.)
Error trigger already exists.
It seems Microsoft's code does not drop the trigger. It checks if the trigger exists but drops a different object.
[Edit]Then I clicked "Send Feedback" but the email address was rejected.[/Edit]
modified 30-Apr-14 6:59am.
|
|
|
|
|
That's so funny because it happens in all of the things Microsoft touches. It just has to be on purpose, it has to be. 
Jack of all trades, master of none, though often times better than master of one.
|
|
|
|
|
It's to make you learn, weed out the code monkeys and all...
|
|
|
|
|
|
I make a nice living because of them. Thank goodness their products are not perfect and they have SDKs to make them better. 
Just saying.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Some would say that it's not a bug, but a feature!
[Flags]
public enum Bool {
True, False, ForSure, Maybe, ProbablyNot, Depends, NotDecidedYet, Undefined
}
private interface IShy { }
|
|
|
|
|
Original Star Wars actors Harrison Ford, Carrie Fisher and Mark Hamill will feature in Star Wars: Episode VII, the latest film in the franchise.
It's a trap!
|
|
|
|
|
As long as the gold bikini doesn't make a reappearance.
|
|
|
|
|
I also hope Carrie Fisher will have changed her hairdressing
[Flags]
public enum Bool {
True, False, ForSure, Maybe, ProbablyNot, Depends, NotDecidedYet, Undefined
}
private interface IShy { }
|
|
|
|
|
Depending on whom it is on. And I do not mean it to be on any of the three!
|
|
|
|
|
You're safe there, Sean bought it at a recent auction for some reason...
|
|
|
|
|
I wonder if Carrie still has her long finger nail.
|
|
|
|
|
When my age you reach, look as good you will not.
The little green guy, I think it was Kermit the frog, was right all along.
The language is JavaScript. that of Mordor, which I will not utter here
I hold an A-7 computer expert classification, Commodore. I'm well acquainted with Dr. Daystrom's theories and discoveries. The basic design of all our ship's computers are JavaScript.
|
|
|
|
|
...and thought of us.[^]
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Cats don't have our social skills and general bon hommie
|
|
|
|
|
To be fair, Griff is more than capable of licking himself in his gentleman's vegetables.
|
|
|
|
|
That's an image that even leaves me needing Mind Bleach! 
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Nagy Vilmos wrote: Cats don't have our social skills and general bon hommie
Given the programmer's I've worked with, I would strongly disagree.
Marc
|
|
|
|
|
I met a well balanced, sociable, extroverted developer once. Once.
|
|
|
|
|
He was a sleeper agent for marketing or sales.
Software Zen: delete this;
|
|
|
|
|
I can assure you most cats have more social skills than me.
But maybe that is just me 
My plan is to live forever ... so far so good
|
|
|
|
|
Dunno. Do you count placing leg-amputated frogs under the couch as a token a love under social skills? Not that that's a kind of skill I'm good at
|
|
|
|
|
Hmmmm..... I never tried that. I wonder if that would have made a difference in any of my failed relationships
I'll have to give it a try in the one
My plan is to live forever ... so far so good
|
|
|
|
|
I thought wire coat hangers are what socks became in the dryer: socks are coat hanger "caterpillars" that morph in to hangers. That's why there is almost always at least one sock missing from the dryer and a new coat hanger in a closet.
Charles Wolfe
C. Wolfe Software Engineering
|
|
|
|
|
Working with some third party software I came across this line in the source.
// Credits: http://www.codeproject.com/KB/cs/enumwithdescription.aspx?msg=649306#xx649306xx
You can go sleep at home tonight if you can get up and walk away
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
