Viewing 9 posts - 1 through 10 (of 10 total)
P Jones (4/3/2013)
WHEN NOT MATCHED BY SOURCE AND (t.ID = s.ID) THEN DELETE;
in the original merge statement.
But I've no complaints about the article...
Al Kessler
It's too bad that
Common Sense Isn't
April 3, 2013 at 5:12 am
Mom always said I was special! Found this while looking for other info on Uppercese and couldn't help tagging on. Noticed afterward how old it is....
Al Kessler
It's too bad that
Common Sense Isn't
May 8, 2012 at 6:01 pm
Through out all this no one has wondered why "Intellisense" can take care of color coding but not capitalization.
What about some settings to implement the "shop standard" for...
Al Kessler
It's too bad that
Common Sense Isn't
May 8, 2012 at 11:50 am
I too was in a quandry trying to resolve the conflict of the last part of option 4. After losing a few hairs I choose poorly. I...
Al Kessler
It's too bad that
Common Sense Isn't
February 1, 2012 at 8:14 am
Per article (Transparent Data Encryption (TDE) SQL Server 2008 by Roy Ernest, 2009/05/04) implementation will not "fail" but will not complete.
"If you look at sys.dm_database_encryption_keys, you will see...
Al Kessler
It's too bad that
Common Sense Isn't
July 18, 2011 at 6:15 am
Joined discussion all set to rant (nicely of course) about "wrong" answer but see I'm too late. Points are great for bragging rights but I like the learning and...
Al Kessler
It's too bad that
Common Sense Isn't
June 28, 2011 at 5:13 am
Not sure what I'm missing but the only one that failed for me was the datetime. Tried British, German, Italian, US_English. Tried dateformat as ymd, dmy, mdy and...
Al Kessler
It's too bad that
Common Sense Isn't
April 13, 2011 at 8:55 am
Goal: Attach these two boards.
Tool: Hammer, Resource: Screw
Hmm?
Yeah, it will work but not the best. However, if you are out of other options (no nails and all the stores...
Al Kessler
It's too bad that
Common Sense Isn't
December 2, 2009 at 8:38 am
I tend to agree with careful use of aliases (make them readable and cogent) because:
I have experienced the ambiguous reference reference error and reacted with "What do mean 'a' is...
Al Kessler
It's too bad that
Common Sense Isn't
May 7, 2009 at 8:10 am
Viewing 9 posts - 1 through 10 (of 10 total)