Viewing 15 posts - 4,711 through 4,725 (of 7,484 total)
mtillman-921105 (3/16/2012)
March 16, 2012 at 2:28 pm
jcb (3/16/2012)
Is there any way to make the snipet below work?
create table test4(
a int null
,b int not null
,c as isnull(a,b*b) primary key
)
GO
Updt: Never mind,...
March 16, 2012 at 1:05 pm
mtillman-921105 (3/15/2012)
L' Eomot Inversé (3/15/2012)
Jack Corbett (3/15/2012)
March 15, 2012 at 9:06 pm
eccentricDBA (3/15/2012)
A.L.I.C.E. (Artificial Linguistic Internet Computer Entity)
ALIcE (Academic Language and Intercultural Exchange)
March 15, 2012 at 7:59 pm
Koen Verbeeck (3/15/2012)
GSquared (3/15/2012)
... world conquest through a secrect society of elite DBAs.
*gasp*
It can be no coincidence that this topic is full of elite DBA's!
(for some strange reason I first...
March 15, 2012 at 2:49 pm
SQLRNNR (3/15/2012)
Basic question. Here's why. Only 4 of the answers are legit evaluation modes. The question asks for four answers.
Actually it's even more basic than that. ...
March 15, 2012 at 1:19 pm
GSquared (3/15/2012)
March 15, 2012 at 12:15 pm
Jack Corbett (3/15/2012)
March 15, 2012 at 12:03 pm
herladygeekedness (3/15/2012)
March 15, 2012 at 11:28 am
Stefan Krzywicki (3/15/2012)
jcrawf02 (3/15/2012)
Stefan Krzywicki (3/14/2012)
March 15, 2012 at 10:19 am
SQL Kiwi (3/14/2012)
manub22 (3/14/2012)
The following blog post will give you differences and performance difference b/w ISNULL() and COALESCE()Check link: http://sqlwithmanoj.wordpress.com/2010/12/23/isnull-vs-coalesce/
It's a reasonable summary of what's already in BOL, but again...
March 15, 2012 at 8:42 am
mtassin (3/15/2012)
Koen Verbeeck (3/15/2012)
Basic, easy question? I never use the damn thing 🙂Thanks for the question, it was very interesting to learn a bit more.
+1 here as well... never use...
March 15, 2012 at 7:43 am
GilaMonster (3/14/2012)
sp_OA* (for those who find CLR too safe)
Some things just never go away. That dates from 6.5, doesn't it?
It's nearly 7 years since Ken Henderson blogged
...With the...
March 14, 2012 at 3:55 pm
A pretty hopeless question. There are at least 2 other answers at least as good as the supposedly "correct" one, and the most glaringly obvious one (the one that...
March 14, 2012 at 1:48 pm
Quite amusing. Lots of fun debate in which only Remi suggested that there was no correct answer, so I think he's the only person who should have got any...
March 14, 2012 at 1:27 pm
Viewing 15 posts - 4,711 through 4,725 (of 7,484 total)