Viewing 9 posts - 1 through 9 (of 9 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...
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....
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...
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...
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...
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...
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...
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...
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...
May 7, 2009 at 8:10 am
Viewing 9 posts - 1 through 9 (of 9 total)