NO COUNT

Question

NO COUNT

Shiva N

Hall of Fame

Points: 3125
More actions
December 10, 2014 at 9:42 pm

#312973

Comments posted to this topic are about the item NO COUNT
Thanks,
Shiva N
Database Consultant
December 10, 2014 at 11:56 pm

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 29 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Carlo Romagnano SSC-Insane Points: 22599 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22599

December 11, 2014 at 12:55 am

#1763961

Extremely easy!

The answer is in the title!

😀

Neil Burton SSC-Insane Points: 22908 More actions · Answer 3

Carlo Romagnano (12/11/2014)
Extremely easy!
The answer is in the title!
😀

The answer might be in the title, but as a newbie I went through my usual process of reading the question, picking an answer after researching the question if needs be, then running the code to double check before actually selecting an answer. However when I did this, I got some data back so I changed my answer and got it wrong. Can anybody suggest why? I'm running 2012.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Arthur Olcot SSCertifiable Points: 6564 More actions · Answer 4

BWFC (12/11/2014)
Carlo Romagnano (12/11/2014)
Extremely easy!
The answer is in the title!
😀
The answer might be in the title, but as a newbie I went through my usual process of reading the question, picking an answer after researching the question if needs be, then running the code to double check before actually selecting an answer. However when I did this, I got some data back so I changed my answer and got it wrong. Can anybody suggest why? I'm running 2012.

The question is what would be the output in the message pane, not the number of rows returned in the results pane.. Judging by the number of people also going for the number of actual records returned (including myself!) many are tripping up on this question and mis-reading the intention

Neil Burton SSC-Insane Points: 22908 More actions · Answer 5

D'OH!!!!!!!!!!!!!!!! :pinch:

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 6

Missread the intention of the query. Knew NOCOUNT would return no counts, but thought it was about what should have been returned! Doh!!!

Nice question and interesting use of the two values clauses.

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Arthur Olcot (12/11/2014)
BWFC (12/11/2014)
Carlo Romagnano (12/11/2014)
Extremely easy!
The answer is in the title!
😀
The answer might be in the title, but as a newbie I went through my usual process of reading the question, picking an answer after researching the question if needs be, then running the code to double check before actually selecting an answer. However when I did this, I got some data back so I changed my answer and got it wrong. Can anybody suggest why? I'm running 2012.
The question is what would be the output in the message pane, not the number of rows returned in the results pane.. Judging by the number of people also going for the number of actual records returned (including myself!) many are tripping up on this question and mis-reading the intention

Actually the question is "How many rows will be affected in the Message Pane" which of course is very sloppy phrasing that doesn't really make any sense; perhaps most people will correctly guess what it was intended to mean (you have, clearly, and I did, in fact probably nearly half of the people who have tried it did as nearly half the answers so far are correct) but others may be confused by it.

This is a nice question, but would have been a much better question if it had been worded correctly.

Tom

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

Arthur Olcot (12/11/2014)
BWFC (12/11/2014)
Carlo Romagnano (12/11/2014)
Extremely easy!
The answer is in the title!
😀
The answer might be in the title, but as a newbie I went through my usual process of reading the question, picking an answer after researching the question if needs be, then running the code to double check before actually selecting an answer. However when I did this, I got some data back so I changed my answer and got it wrong. Can anybody suggest why? I'm running 2012.
The question is what would be the output in the message pane, not the number of rows returned in the results pane.. Judging by the number of people also going for the number of actual records returned (including myself!) many are tripping up on this question and mis-reading the intention

It isn't. Here's the question again: "How many rows will be affected in the Message Pane from the below query?" and the answer of course is 1. That single row contains the text "One row(s) affected" or whatever.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Tricky question, but very nice as well, I was about to choose the (1 row(s) affected) option, but re-read the qusetion slowly, got it right.

Thanx 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

Carlo Romagnano (12/11/2014)
Extremely easy!
The answer is in the title!
😀

+1 😉

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

OCTom SSChampion Points: 11785 More actions · Answer 11

Stewart "Arturius" Campbell (12/10/2014)
Interesting question, thanks Shiva
Never thought of doing an implicit cross join of two VALUES constructs before...

Same here. That's what caught my attention.

Bobby Russell SSCrazy Points: 2801 More actions · Answer 12

I'm to the point now if Shiva N posts the question, I'm skipping it.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 13

The message pane was the clue that we needed to be in grid mode, not text mode. Then seeing the no count on made the answer jump out for me. I use that feature in most of my stored procedures.