Viewing 15 posts - 1,771 through 1,785 (of 3,348 total)
manik123 (4/23/2013)
but where is the group by.....???? it is working without group by.....?????
If the SELECT clause of a query contains ONLY aggregate functions, you can leave out the GROUP BY....
April 23, 2013 at 7:29 am
Mr. Kapsicum (4/23/2013)
Choice two: SELECT ID, COALESCE(IsAvailable, GETDATE()) FROM #Test
...
April 23, 2013 at 7:27 am
The first sentence of the explanation should probably have read "Instead of triggers can cascade regardless of the setting of the nested trigger server option."
The question IDEA is very good....
April 23, 2013 at 2:46 am
ramana3327 (4/19/2013)
Is it possible to insert values in only one column? Actually there are two columns in table they updating only one column what will happen to second
The other column...
April 20, 2013 at 3:13 am
Mike Dougherty-384281 (4/19/2013)
How does the trigger affect multi-row insert if one fails the trigger condition? How would that scenario be different with CHECK constraint?
The trigger would roll back the...
April 19, 2013 at 8:16 am
L' Eomot Inversé (4/19/2013)
April 19, 2013 at 4:55 am
Christian Buettner-167247 (4/19/2013)
There is one subtle issue with the explanation (and also the MS documentation).
It is not the ROLLBACK that is causing the abort of the batch. Instead, the...
April 19, 2013 at 2:18 am
Danny Ocean (4/19/2013)
Hugo, Question title is "Triggers 1", so everybody look at trigger (even be also). But trick was in "GO"I think question title should be "GO". 🙂
Try what happens...
April 19, 2013 at 1:40 am
kapil_kk (4/18/2013)
oopes,I think I have misunderstood the way to execute the given query...
Oohhh, I am so sorry that the comments in the code made you misunderstand the question. I added...
April 19, 2013 at 12:32 am
Dineshbabu (4/18/2013)
If insert statement was within Explicit transaction then even first row will not be inserted and the result of final query will be 0. Am I right?
Yes (assuming you...
April 19, 2013 at 12:29 am
TaylorMade (4/18/2013)
April 18, 2013 at 7:14 am
Dineshbabu (4/18/2013)
Is there anyway to make COUNT() to consider even NULL values?? I mean any set options or something like that?
Yes. Just use COUNT(*).
April 18, 2013 at 6:17 am
Good question. Not perfect, though.
When I read the question in the daily newsletter, I expected the answer options to be "yes" or "no", and I was fully ready to reply...
April 17, 2013 at 2:21 am
mark.gilbert (4/16/2013)
Am I missing something, or is this the exception to the rule?
What Lynn said. 🙂
For ensuring that the empty string is not treated as numeric, I would personally not...
April 16, 2013 at 1:42 pm
rals (4/16/2013)
(...)The above code returns 5, 5, 4. Based on the output it looks like COUNT(*) and COUNT(1) returns the number of rows, regardless of content.
COUNT(*) returns the number of...
April 16, 2013 at 8:39 am
Viewing 15 posts - 1,771 through 1,785 (of 3,348 total)