Viewing 15 posts - 271 through 285 (of 455 total)
andrew.diniz (4/26/2012)
Nice article!It's also interesting to note that ordinal positions returned by a CASE statement are not implicitly resolved to field objects.
That's because a CASE statement CAN'T return ordinal...
April 26, 2012 at 5:44 am
*facepalm*
Let me see if I can explain this much more simply:
ORDER BY takes as its arguments a set of expressions, each optionally followed by a direction indicator, separated by commas.
Essentially,...
April 26, 2012 at 5:11 am
Revenant (4/24/2012)
Well maybe it was not so easy -- currently only 25 percent of correct answers. That's the lowest one I have seen in a long time.
Yes, it looks like...
April 24, 2012 at 11:55 am
Thomas Abraham (4/24/2012)
April 24, 2012 at 7:02 am
DugyC (4/18/2012)
ps. Our 2008R2 upgrade...
April 18, 2012 at 7:07 am
Schadenfreude-Mei (4/17/2012)
deleted due to embarrisment.
We did kind of jump on you, didn't we? Rest assured it wasn't intended (I know when I wrote my post, the other two weren't there)....
April 17, 2012 at 4:10 pm
Schadenfreude-Mei (4/17/2012)
Msg 343, Level 15, State 1, Line 1
Unknown object...
April 17, 2012 at 10:30 am
call.copse (4/16/2012)
sknox (4/16/2012)
call.copse (4/16/2012)
See this MSDN blog entry...
April 16, 2012 at 9:35 am
call.copse (4/16/2012)
See this MSDN blog entry which clearly...
April 16, 2012 at 7:44 am
Jack Corbett (4/9/2012)
sknox (4/9/2012)
Sean Lange (4/6/2012)
sknox (4/6/2012)
Sean Lange (4/6/2012)
... Basically you can simulate a foreign key via triggers but it is NOT actually a foreign key.
NO.
Any column in...
April 9, 2012 at 11:31 am
Sean Lange (4/6/2012)
sknox (4/6/2012)
Sean Lange (4/6/2012)
... Basically you can simulate a foreign key via triggers but it is NOT actually a foreign key.
NO.
Any column in a table is a foreign...
April 9, 2012 at 7:21 am
Sean Lange (4/6/2012)
... Basically you can simulate a foreign key via triggers but it is NOT actually a foreign key.
NO.
Any column in a table is a foreign key column if...
April 6, 2012 at 11:38 am
Jeff Moden (3/26/2012)
dwain.c (3/26/2012)
I can't wait for the purists to berate you for using...
March 26, 2012 at 9:15 am
Got it right, even though it was an (educated) guess. My work with SQL Server introduced me to the YYYY MM DD date order, and to me it's the most...
March 23, 2012 at 9:12 am
Very nice article. It provides a set of useful solutions to a common issue, while also highlighting the fact that some common "mantras" (i.e, Inline TVFs are more efficient than...
March 23, 2012 at 8:38 am
Viewing 15 posts - 271 through 285 (of 455 total)