Viewing 15 posts - 31 through 45 (of 1,033 total)
Koen Verbeeck (11/13/2013)
Secondly, developer is the same as enterprise feature-wise,...
November 13, 2013 at 8:23 am
I sort of did it like Tom
I knew that LAG and LEAD and PERCENT_RANK were all 2012 features (and some of the reasons we wanted 2012).
November 11, 2013 at 9:49 am
Rune Bivrin (11/1/2013)
Well, good question, but the correct alternative was a bit misleading. You don't get a zero back, you get an empty result set. That's a different answer.
QFT, :)...
November 1, 2013 at 7:30 am
Dscheypie (10/31/2013)
October 31, 2013 at 10:31 am
ronmoses (10/31/2013)
October 31, 2013 at 10:24 am
IgorMi (10/17/2013)
If you use exec sp_recompile 'T'you'll get results (compiled values) "Kelle" and "Pelle"
If you use exec sp_recompile 'GetIt'
you'll get results (compiled values) "Kelle" and "Urban"
Which is what I did......
October 17, 2013 at 1:31 pm
raulggonzalez (10/7/2013)
It might be good also to point that table variables are not affected either by transaction rollbacks.
As per BOL
Because table variables have limited scope and...
October 7, 2013 at 8:00 am
L' Eomot Inversé (9/25/2013)
September 25, 2013 at 7:06 am
paul s-306273 (9/25/2013)
...come on, maybe they were really impreseed, but I doubt they 'gasp in wonder'!
Mine did... 3 years ago when I showed them how to do some of these...
September 25, 2013 at 7:01 am
Carlo Romagnano (9/25/2013)
Koen Verbeeck (9/25/2013)
Very interesting question. Never used a CTE with a DELETE statement before.+0.5
Never used a CTE at all.
This I find amazing... do you not use the Window...
September 25, 2013 at 6:59 am
paulcauchon (9/19/2013)
Perhaps even less often-- I can't think of a single instance where a code block wrapped in if 1=0 would be a useful design element.
I've used stuff like that...
September 20, 2013 at 7:36 am
Stewart "Arturius" Campbell (9/18/2013)
Good question, Ron, thanksDidn't even have to bother executing the T-SQL, which is, after all, what this is all about...
Yes... yes it is... I too can claim...
September 18, 2013 at 9:33 am
Good... so rather than googling myself to death trying to come up with the correct term.
I believe it's because of the IF/THEN that we see this.
SQL Processes both branches of...
September 16, 2013 at 9:19 am
Koen Verbeeck (9/15/2013)
There's no reference, and the explanation itself is incorrect.
There's no variable that is "reset".
The DECLARE is not ignored, it...
September 16, 2013 at 8:40 am
Koen Verbeeck (9/13/2013)
Very nice question to close off the week.And kudos for mentioning the default language, so there's less whining in the discussion 😀
Yah I thought that was a nice...
September 13, 2013 at 10:57 am
Viewing 15 posts - 31 through 45 (of 1,033 total)